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."