Macro to create searchable data validation+combobox

[Akuini]

Any update on my requests Akuini?

Sorry, for the really late reply.
Are you still looking for the solution?
I have time to revisit the code this week.

 

[AlecJK]

How can I make this work without .NET 3.5? We have .NET 4.0 and I can't install 3.5 on all users machines.

 

[Akuini]

How can I make this work without .NET 3.5? We have .NET 4.0 and I can't install 3.5 on all users machines.

Which version of searchable combobox are you using? version A,B or C?
I can amend the code so you don't need to install NET 3.5.
Do all users machines use Excel 365 or later? If so then I will use the new SORT function.

 

[AlecJK]

I was trying to get version B working. Yes, all users are on Excel 365 or later. Thanks!

 

[Akuini]

I was trying to get version B working. Yes, all users are on Excel 365 or later. Thanks!

Ok, try this new version of VERSION B - ACTIVATED AUTOMATICALLY, works on Excel 365 or later:
You don't need to install Net Framework 3.5.
It uses the new SORT function.

New feature:
- clicking an item in the combobox will also send the value to the cell.

Akuini - xCOMBOBOX+DAVAL-ON-OFF,automatic,365-1

MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.

www.mediafire.com

 

[AlecJK]

Ok, try this new version of VERSION B - ACTIVATED AUTOMATICALLY, works on Excel 365 or later:
You don't need to install Net Framework 3.5.
It uses the new SORT function.

New feature:
- clicking an item in the combobox will also send the value to the cell.

Akuini - xCOMBOBOX+DAVAL-ON-OFF,automatic,365-1

MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.

www.mediafire.com

This worked. Thanks for the help!

 

[Akuini]

This worked. Thanks for the help!

You're welcome.
And if you're interested, you can also have autocomplete/searchable functionality by using a free Excel add-in called "Search deList". You can find it here:

I created an Excel add-in called “Search deList”, to create searchable data validation

I created an add-in called “Search deList”, and I share it as a freeware. Its function is to speed up searching in data validation list. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a Userform with a combobox. You can type multiple keywords (separated by a...

www.mrexcel.com

By using this add-in you don't need to have macro in your workbook to have this searchable combobox.