Drop Down Lists

[mr_teacher]

Hi all,

I have spreadsheet set up that uses several drop down boxes.

Is there any way to get these to autocomplete - ie when I start typin
letters into the drop down box it will fill in the rest of the possibl
name for me?

Thanks for any advice

Car

 

[Dave Peterson]

You can do it if you used the combobox from the control toolbox toolbar.

What did you use to create the dropdown boxes?

 

[mr_teacher]

You can do it if you used the combobox from the control toolbox
toolbar.

What did you use to create the dropdown boxes?

HI Dave,

I used data validation to create the drop dow lists. Not too sure on
how to use comboboxes to perform this function to be honest!!!

Carl

 

[Gord Dibben]

Carl

Debra Dalgleish has done most of the work for you.

Visit her site for instructions on DV using Combo Box.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

 

[mr_teacher]

Thanks for the link Gord - that seems to be what I am after and I'l
have a good go at them!

Can these drop down lists as combo boxes be used to create dependan
lists as described in other parts of the article?

Car

 

[Debra Dalgleish]

The combobox shows what's in the data validation list for the selected
cell. So, if you set up dependent data validation, it will be displayed
in the combobox. There's an example here:

http://www.contextures.com/excelfiles.html

Under data Validation, look for 'Dependent Data Validation Combobox'

 

[mr_teacher]

Thanks a lot for that Debra - I'll give it a go!!

Car