Search Function - User Form

Hi all,

First, sorry if this has been answered before, I have had a quick look using the search function and couldn't see anything to match my needs.

Basically I have a userform called Main at the moment it has a combobox that has 115 items (yup quite a lot) in the list, when one of the items is selected it automatically opens a form associated with the selected item. As you can imagine if a user is in a hurry then scrolling through the list can be tedious, especially as there are a few sites with almost identical names, only different based on the role the site plays (Accomodation and tool hire are examples).

I would like to introduce a search function to the form, so that when a user enters the search criteria, which can be either number or name, the results are displayed, from which the user can select the appropriate form to open.

So for example, I could have the following -

Site Numbers:Site Name
1:Elephant Ears
2:Elephant Trunk
3:Lion Rawr
4:Elephant Feet
5:Tiger Purr

When a user searches for the specific number (1,2,3,4,5) it will display the appropriate result, but if for example they enter Elephant or Ele then only items 1, 2 and 4 will be displayed, then when the user selects one, it opens the relevant form.

Is this possible?

Sorry for the long winded question / explanation.

Anyone?

No one?
Well, I guess ignorance is bliss.