LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 709
Default data validation quick find

I have a long list of names in the validation database, so scrolling through
the entire list takes a long time.

Is there a way to set up the name find so that as a user starts to type in
the first letters of a name it automatically goes to the right name?

For example if they type "M", it goes to first name starting with "M"; and
if they continue "ME" it goes to first name starting with "ME"?

If basic Excel does not have this feature, do you know of any add-ins or
third party additions that cover this feature?
--
Richard
 
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
Code to find data validation in a cell DaveO[_2_] Excel Discussion (Misc queries) 1 March 19th 07 05:53 PM
Excel: Find/Replace for Data Validation text or Worksheet Objects [email protected] Excel Discussion (Misc queries) 3 May 22nd 06 07:16 PM
Shortcut Keys -- quick find scottech Excel Discussion (Misc queries) 3 November 15th 05 08:08 PM
Data Validation / find & replace Penny Excel Discussion (Misc queries) 1 July 20th 05 08:45 PM
excel quick find format chris Excel Worksheet Functions 1 February 9th 05 03:17 AM


All times are GMT +1. The time now is 08:27 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"