VBA for searchable dropdown

[IKHAN]

Excel wizards - Need on a macro to perform a searchable drop down list (Like google , Type in T in a cell dropdown shortlist starting with "T" or "club" shortlist club from list IN Colum A and same with groups dropdown(Col C), Have long list in dropdrown items and its difficult to pick by scrolling.

Tab (2. Planning) - column A (R13:R18) has drop down list co related to Column C(Groups) R13:R18

same macro should apply to all dropdowns in spreadsheet.

Note :Tried data validation and CF, but was able to apply to just 1 cell,unable to do same setup to below cells.

Have uploaded sample file

 

[Chihiro]

You can accomplish it by combining couple of things.

Named Range (it can be dynamic).
Data Validation
ActiveX ComboBox

See link and follow instructions.
http://www.contextures.com/xlDataVal11.html

You can also combine dependent list to the mix as well.

 

[Chihiro]

Found a project I worked on that uses above method.

Stripped out version attached as an example. Protected sheet can be unprotected without password.

 

[IKHAN]

Found a project I worked on that uses above method.

Stripped out version attached as an example. Protected sheet can be unprotected without password.

@Chihiro .. Couldn't figure it out .. need searchable drop down for c1r1,c1r2,c1r3.....

 

[Chihiro]

Did you follow step by step instruction given in the link?

I'd recommend first creating basic set up using example given in the link. See if you can get that to work. If having issues with that, let me know where you are having issues.

P.S. I realized I forgot to remove one of the references not needed in previous attachment.