View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Siobhank Siobhank is offline
external usenet poster
 
Posts: 1
Default 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