ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Search and Match Values (https://www.excelbanter.com/excel-programming/420902-search-match-values.html)

CROD

Search and Match Values
 
I am trying to avoid having to scroll through an existing ListBox to find a
name. The existing ListBox references a column/list of names within a
database.

I would like to have a user find a name within the ListBox by entering the
"name" into a TextBox, which then finds the ExactMatch name in the referenced
ListBox.

If there is an ExactMatch, Then the "name" in the ListBox is highlighted or
selected.

I would greatly appreciate your assistance with this.



JLGWhiz

Search and Match Values
 
You can do that, but why would you want to when you can just as well work
right from the text box? Iif the user types the name in and presses enter,
you could write the code to do the same thing that the listbox does if the
name is selected there.

"CROD" wrote:

I am trying to avoid having to scroll through an existing ListBox to find a
name. The existing ListBox references a column/list of names within a
database.

I would like to have a user find a name within the ListBox by entering the
"name" into a TextBox, which then finds the ExactMatch name in the referenced
ListBox.

If there is an ExactMatch, Then the "name" in the ListBox is highlighted or
selected.

I would greatly appreciate your assistance with this.




All times are GMT +1. The time now is 08:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com