Dropdown List Help

[benhickman]

Hi,

I really hope someone can help me make this drop down list.

I have a cell that a user will type in a acronym. Cell B1

I have a range of acronyms in a separate tab (about 700 of them).

I would like the user to presented with a drop down list of cells within the range that contain those three characters and any other cells that has any other characters after what they have typed. Like a wild card.

Is this possible?

Please please please help.

Thank you

 

[Candyman8019]

If you're able to join the "Office Insider" beta program, that version of Excel natively has the typeahead functionality, so you can have a normal data validation field and as you type, it will filter the list accordingly.

 

[benhickman]

I am unable to join to work limitations

 

[Candyman8019]

I think there are several methods people have used to accomplish this. Here's one way: Show Excel Data Validation Drop Down Items in Combo Box

 

[benhickman]

I think there are several methods people have used to accomplish this. Here's one way: Show Excel Data Validation Drop Down Items in Combo Box

Thank you, but I have had a look at that page and I can't see where it goes into specifying results in a range to appear in the drop down box

 

[Candyman8019]

your range will go in the ListFillRange field.

One thing important to note, is to use the ActiveX combobox rather than the form control combobox. this way you'll see these additional items in the properties window.

 

[benhickman]

Thank you. I can give that a go, but reading that it is a bit confusing.

Is it not possible to be formular driven?

 

[Candyman8019]

You will need VBA to achieve the typeahead feature. I don't mind giving you a hand if you share a copy of your worksheet via onedrive or dropbox.

 

[benhickman]

You will need VBA to achieve the typeahead feature. I don't mind giving you a hand if you share a copy of your worksheet via onedrive or dropbox.

Thank you.

I have uploaded to one drive here:

BenHickmanExample.xlsx

Microsoft Excel Workbook

1drv.ms

 

[benhickman]

You will need VBA to achieve the typeahead feature. I don't mind giving you a hand if you share a copy of your worksheet via onedrive or dropbox.