Chip,

I am also interested in doing this. Is there a good tutorial on setting up a
combobox from the controls menu so that the user can just type some text to
select an entry?

Phil.

"Chip Pearson" wrote:

If you are using a combobox from the controls menu, set the
AutoWordSelect property to True. If you are using a data
validation dropdown, you can't do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Excel Novice" <Excel wrote in
message
...
I'd like to save time selecting from a drop down list by typing
the first few
letters of textl and have the cell "auto fill."