Vacuum Sealed pretended :
Hi Hakan

I know in Access Forms.Combobox property you can set it's "Limit to List" to
=Yes so that it only looks a names within the list and as you type in each
character, the names/words update at the same time.

I'm not all that experienced with Excel Comboboxes and am unaware if they
have similar property settings.

Garry Maybe able to provide extra insight into that particular property
setting.

HTH
Mick.

Hi Mick,
You can duplicate the Access ComboBox behavior in Excel by using the
Change event to run a procedure that reloads the list based on the
characters typed into the combobox. Also, the same 'effect' can be
achieved using the Change event for a TextBox and populating a ListBox
where users can make selections.

The latter is how the Index tab in online help works: as you type
characters in the 'keywords' textbox the 'choose keywords' textbox
scrolls to match the typed characters. This behavior demos the 'effect'
of using the Change event. In the OP's case this could be modified to
display the desired list items. Note that the same thing -could- be
done with a combobox but using the textbox/listbox together is, IMO,
more intuitive.<g

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc