DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING
 

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?

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?