DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING

[Bellyjean]

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?

 

[Ron Coderre]

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)