Selecting Combo-box entry by typing

R

Rob

....any ideas on how I can setup a combo-box so that the
user can select an item from the list by typing text OR
by using the mouse? I want to execute a macro once an
item is selected.
E.g., if the items in my combo box
are "AXE", "HAMMER", "NAIL", "SCREW", and "SCREWDRIVER",
I want the user to be able to type "N" and have "NAIL"
selected, OR use the mouse to select "NAIL". I then want
a macro to execute (if I have the user type text, they
would presumably have to hit "enter" or something -- so
that I know when they are finished typing: if they
type "SCREW", there needs to be a way of determining if
they really want the "SCREW" entry or if they are part
way through typing "SCREW...DRIVER".

The "FORMS" combo-box doesn't seem to allow selection of
an entry by TYPING. The "CONTROLS" combo-box DOES, but I
can't find out how to initiate a macro, or how to prevent
the user from being able to type something that is not i
the combo-box list.

Thanks for your help!

Rob
 
B

BrianB

Select Control & from Right Click menu /Properties :-

ListFillRange = options list
Linked Cell = result (or use .Value in code)
Match Required = True
Match Entry - experiment with options (see MatchEntry property in Help)
 
Top