View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING

You can get what you're asking for
....BUT not actually using DV
....and it may not be worth the effort.

See Debra Dalgleish's website for instructions:
http://www.contextures.com/xlDataVal10.html

I hope that helps,
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"Bellyjean" wrote in message
...
I wish to select a name from a data validation list by using the first
letter
of the name so I don't have to scroll down to the name, is this possible?