Posted to microsoft.public.excel.worksheet.functions
|
|
How do I select form a drop down box by typing the first part?
Thank you so much!
"Gord Dibben" wrote:
Data Validation drop-downs do not allow for autocomplete.
To get that feature you need a combo-box.
Debra Dalgleish has done the work for you.
http://www.contextures.on.ca/xlDataVal10.html
Gord Dibben Excel MVP
On Tue, 22 Nov 2005 12:45:05 -0800, StacieKTU
wrote:
I have created a drop down box with many entries in it. Is there a way I can
begin typing and have it find the first match and then select with the mouse
the right one?
|