DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING

B

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?
 
R

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)
 
Top