How to using Combo box like As Searchable Dropdown list ? And easy coding For Two OR More Combo box using VBA

[krunal123]

View attachment 92479

# How to using Combo box like As Searchable Dropdown list ? And easy coding For Two OR More Combo box using VBA

Query 1 : i was copy paste Combo box but not using like Combo box 1 to other column
Query 2 : i will increase & decrease cell size at time auto set Combo box size
Query 3 : can i use Combo box 1 to using particular range like searchable dropdown list ????????????????????

 

[Akuini]

If you're interested, here's an example of a searchable drop-down:

Macro to create searchable data validation+combobox

Akuini submitted a new Excel article: Macro to create searchable data validation+combobox - Speed up searching in long list data validation & easy to set various specific behaviors Excel doesn't provide a built-in way to search data validation list. So it could be hard to scroll through the...

www.mrexcel.com

OR

Another option:
I created an Excel add-in for searchable data validation (with combobox) , called "Search deList".
Its function is to speed up the search in the data validation list. It works on multiple cells. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a User Form with a combobox. You can type multiple keywords (separated by a space) in the combobox to search items on the list.
It works on any cells that have data validation on any workbook, and you don't need VBA for this.
I share this add-in 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