Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match formula to match values in multiple columns | Excel Discussion (Misc queries) | |||
how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
Search Column, If match found then add two values. | Excel Programming | |||
How to Search, Count, Match and Post Values | Excel Worksheet Functions | |||
Search/Filter to find values in another range based on two cell values | Excel Programming |