View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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