Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I make a TextBox search through a ListBox?
- Thread starter JESTAR
- Start date
- Thread starter
- #2
Hi!
Use the following code in your button's click event:
Dim intRow As Integer
For intRow = 0 To Me!YourListBox.ListCount - 1
If Me!YourListBox.Column(0, intRow) = YourTextBox.Value Then
Me!YourListBox(intRow).Selected = True
Exit For
End If
Next intRow
A couple of things to note, in the column property you will use the column number that holds the data of interest, if the data is in the bound column you can use .ItemData(intRow) instead. Doing the search this way allow for an exact match only, so if no match is found(you can use a boolean variable to track that) you may want to display a message box with an appropriate comment.
hth
Jeff Bridgham
bridgham@purdue.edu
Use the following code in your button's click event:
Dim intRow As Integer
For intRow = 0 To Me!YourListBox.ListCount - 1
If Me!YourListBox.Column(0, intRow) = YourTextBox.Value Then
Me!YourListBox(intRow).Selected = True
Exit For
End If
Next intRow
A couple of things to note, in the column property you will use the column number that holds the data of interest, if the data is in the bound column you can use .ItemData(intRow) instead. Doing the search this way allow for an exact match only, so if no match is found(you can use a boolean variable to track that) you may want to display a message box with an appropriate comment.
hth
Jeff Bridgham
bridgham@purdue.edu
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
