Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default Data Validation and a Long List. An Easier Way?

I am using Data Validation and allowing the user (me) to select a
value from a Drop Down list. This part works fine; the list is
alphabetized, and the values are easy to find.

The issue is that the allowed values list is about 450 values long.
And scrolling through the list takes longer than I would like. I can
use ALT-(arrow keys) to get the list to drop down, and then use Page-
Up, Page-Down and the up and down arrows to navigate through the list.

Ideally, I'd like to be able to type in the first few letters of the
value and jump to that part of the list. Is there an easy way to
achieve to this functionality?

Reply
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
Search for a specific entry in a long data validation list Heinrich Excel Discussion (Misc queries) 1 May 4th 07 07:29 PM
Formula too Long for List Validation JB Excel Discussion (Misc queries) 3 April 6th 07 07:11 PM
data validation invalid in dynamic validation list ilia Excel Discussion (Misc queries) 0 November 7th 06 12:54 PM
data validation invalid in dynamic validation list ilia Excel Worksheet Functions 0 November 7th 06 12:54 PM
Retrieve multiple data rows data from a very long list and copy t mathew Excel Discussion (Misc queries) 1 September 13th 06 08:24 PM


All times are GMT +1. The time now is 05:49 PM.

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"