View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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.