Help! Autofilling Data Validation Pulldowns

  • Thread starter Thread starter Barb
  • Start date Start date
B

Barb

How do I get a List Pulldown from Data Validation to
Autofill when users enter the first letter(s)?
 
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
 
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.
 
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

How to set excel pulldown list starting value to current cell valu 1
Auto fil in 2
Pull Down Menus 3
Data Validation - List 1
Adding more space in a pulldown box? 2
Macro to autofill from a specific row to a specific row 2
Autofill defaults 4
HELP!!! I need macro to autofill 4

Back
Top