View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Possible to Filter a Listbox on a form?

s
Maybe...

Private Sub CommandButton1_Click()
ListBox1.RowSource = vbNullString
ListBox1.AddItem TextBox1.Value
End Sub

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"skuzapo" wrote in message
The problem I'm having with this is that the list contains a few
thousand lines. I need to be able to filter the listbox to show just
one record - based on the entry in a textbox.
Any further help would be appreciated.
Thanks
skuzapo