Data Validation List- Auto-Type

B

Ben

When you have set up a Data Validation that includes a
list with a drop-drop down how do you set it to auto-fill
as you start typing?

Ben
 
B

Ben

Thanks, Frank.

How would you accomplish it with using the 'built-in'
data validation?

Ben
 
F

Frank Kabel

Hi Ben
you may use a Combo Box from the toolbar 'Toolbox'. This supports this
kind of autofill. But it is not the same as data validation (other
appearance, etc.)
 
G

Guest

Thanks Frank,

I will try using that route!

PS--What do you recommend as the best book to help you
master EXCEL and Visual Basic?

Thanks Ben
 

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

VALIDATION 1
dates from a data validation 3
Created invoices in Excel - not working in Drive 1
Drop down fill box does not appear when cell clicked. 1
Data Validation 1
How do I get drop-down list that includes, eg top10 1
Data Validation Lists 5
25#Data Validation 4

Top