DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING

  • Thread starter Thread starter Bellyjean
  • Start date Start date
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?
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation - Excel 2007 5
Data validation - combo box 4
drop down list 3
Data Validation List - Can I have multiple ranges displayed? 4
Data Validation 4
Amend the DV0022 - Update Validation Selections code for more lists 1
Validation list from Named Ranges 5
using pulldown list with a list and autocompleet function 3

Back
Top