LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I set a drop down list to scroll to a letter by typing it? Kelly_Branegan Setting up and Configuration of Excel 1 September 3rd 08 09:51 PM
How do I set up a drop down list to beginning letter of item? kerri Excel Discussion (Misc queries) 1 August 10th 06 06:56 PM
how do I make drop-down list select based on 1st letter entered? Missykender Excel Discussion (Misc queries) 3 October 6th 05 11:55 PM
Using a drop down list -- Autojump to first letter Siobhank Excel Discussion (Misc queries) 3 August 11th 05 03:12 PM
press letter and go 2 entry begin w letter in data validation drop MCP Excel Programming 1 August 28th 04 05:07 PM


All times are GMT +1. The time now is 03:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"