Akuini
Well-known Member
- Joined
- Feb 1, 2016
- Messages
- 5,089
- Office Version
- 365
- Platform
- Windows
Sorry, for the really late reply.
Are you still looking for the solution?
I have time to revisit the code this week.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Macro to create searchable data validation+combobox
- Thread starter Akuini
- Start date
Are you still looking for the solution?
I have time to revisit the code this week.
Excel Facts
Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Akuini
Well-known Member
- Joined
- Feb 1, 2016
- Messages
- 5,089
- Office Version
- 365
- Platform
- Windows
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.
Akuini
Well-known Member
- Joined
- Feb 1, 2016
- Messages
- 5,089
- Office Version
- 365
- Platform
- Windows
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!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
Akuini
Well-known Member
- Joined
- Feb 1, 2016
- Messages
- 5,089
- Office Version
- 365
- Platform
- Windows
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...
