Help! Autofilling Data Validation Pulldowns

B

Barb

How do I get a List Pulldown from Data Validation to
Autofill when users enter the first letter(s)?
 
J

Jason Morin

What you can do is place the source range for the
validation list directly above the validation cell, then
hide those rows.

HTH
Jason
Atlanta, GA
 
D

Dave Peterson

And just to add to Jason's reply, I think you'll want to turn on:

Tools|options|edit tab|Enable Autocomplete for cell values.

Another option may be to just add a combobox from the controltoolbox toolbar.
There's a setting there that allows you to match the entry (.matchentry). And
with the .style set to fmstyledropdownlist, it might suffice.
 
Top