Validation List AutoFill

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I had the understanding the cells with validation lists could not be
autofilled. For example if I have a list of three people

Tim
Jake
Jim

and I type J in the cell it autofills Jake, but if I type Ji it autofills
Jim. I thought that this wasn't possible, but I just downloaded and Excel
worksheet from VS.NET that Microsoft makes that utilizes a validation list
that autofills. Does anyone know how to make that happen, or is it a
programming issue that I need to put in the Excel Programming Discussion
Group?

Thanks,
ACFalcon
 
You need a combobox from the control toolbox toolbar for that

put it in the cell, right click it, select view properties, put the cell
range in the ListFillRange as

A1:A10 (no equal sign)

select

0-fmMatchEntryFirstLetter

in the MatchEntry option

close it, then click the triangular ruler to leave design mode
 

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

Create a custom fill series or sorting order 1
Autofill cell references with a pattern of every 110 rows 3
How do I get AutoFill to fill dates with time without rounding. 5
how can i get Excel to autofill an unusual sequence? 3
Conditional formulas between multiple worksheets 1
Autofilter Issue 4
data validation 2
Automatically open list box on entering the cell 1

Back
Top