Use word to associate an item in validation drop down list

O

Otani

I have created a validation drop down list but because the list can be quite
long I want to be able to type a specific word on the cell that would
associate that specific item in the drop down list.

For example, lets say my drop down list contains the months of the year from
January to December. I want to associate 1 = January and 2 = February and so
on so that when I enter 6, June comes up on the cell.

Does anyone know if this is possible on Excel?
 
G

Gord Dibben

Could be done with VBA event code but your list would have to consist of
numbers 1 to 12.

Type a number and the appropriate month is displayed in the cell.

Or you can use a combobox in conjunction with the DV dropdown that will
allow autocomplete.

i.e. type d and December is displayed.

For the latter see Debra Dalgleish's site.

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


Gord Dibben MS Excel MVP
 
O

Otani

Thanks for the reply. Unfortunately I don't understand the VBA code so I
ended up creating names for the items in the drop down list which did the
trick for me.
 

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

Top