Using a drop down list -- Autojump to first letter
 

I have a spreadsheet with many many drop-down lists. Is there any wa
for a user to enter the first letter of an option and automaticall
jump to that option in the list?

The goal is to make this faster to use than (or at least as fast as
writing it out, and right now, clicking on, scrolling through, an
selecting from each drop-down is a lengthy process

--
Siobhan
-----------------------------------------------------------------------
Siobhank's Profile: http://www.excelforum.com/member.php...fo&userid=2613
View this thread: http://www.excelforum.com/showthread.php?threadid=39461

Using a drop down list -- Autojump to first letter
 

Not supported in data validation dropdowns.

--
Regards,
Tom Ogilvy

"Siobhank" wrote in
message ...

I have a spreadsheet with many many drop-down lists. Is there any way
for a user to enter the first letter of an option and automatically
jump to that option in the list?

The goal is to make this faster to use than (or at least as fast as)
writing it out, and right now, clicking on, scrolling through, and
selecting from each drop-down is a lengthy process.


--
Siobhank
------------------------------------------------------------------------
Siobhank's Profile:
http://www.excelforum.com/member.php...o&userid=26133
View this thread: http://www.excelforum.com/showthread...hreadid=394612

Using a drop down list -- Autojump to first letter
 

Gotcha.

I found out it has to be a combobox from the control toolbar. Once I
have a combobox from the control toolbar, how do I enter my list
values? How do I set matchentry?


--
Siobhank
------------------------------------------------------------------------
Siobhank's Profile: http://www.excelforum.com/member.php...o&userid=26133
View this thread: http://www.excelforum.com/showthread...hreadid=394612