Combox is slow and floats in other sheets

[promo1313]

Hi,

I used a combox that fills as you type in a project with a long list. I used this option instead of the regular dropbox, because at time we have more than 1000 options to choose from, and it easier for the user to start typing and selecting.

The only issue I am having with the combox, is that it is really slow, and sometimes crashes the project. Also, at times, it seems to appear in other sheets on the same document workbook, or if I have another workbook open, it pops up there Iis there a way that this can be sped up with vba? Or is there maybe an option in the preferences that I need to change?

Any help would be of great assistance.

this is the code that I have for the combobox

Private Sub ComboBox1_Change()
ComboBox1.ListFillRange = "Dropdown"
Me.ComboBox1.DropDown
End Sub

 

[Legacy 456155]

Remove:
ComboBox1.ListFillRange = "Dropdown"

Assign DropDown to the ListFillRange property initially, one time, in your properties window. (without the quotes)

 

[promo1313]

Remove:
ComboBox1.ListFillRange = "Dropdown"

Assign DropDown to the ListFillRange property initially, one time, in your properties window. (without the quotes)

View attachment 7275

Thanks for the reply Data, but I checked the settings and thats how its set up.

 

[Akuini]

Here's an example of a searchable combobox with VBA:
deCombobox - sheet,1 cell, searchable,filter - example 1.xlsm

You can adjust the code in this part:

'=============== YOU MAY NEED TO ADJUST THE CODE IN THIS PART: ===================================

'sheet's name where the list (for combobox) is located. [in the sample: sheet "deList"]
Private Const sList As String = "deList"

'cell where the list start [in the sample: cell A2 in sheet "deList" ]
Private Const sCell As String = "A2"

'the linked cell
Private Const xCell As String = "B3"

And if you want a searchable combobox for multiple cells, here's an example:
best-way-to-create-a-searchable-drop-down-list-with-auto-complete-functionality-to-cells-in-a-column

 

[promo1313]

Here's an example of a searchable combobox with VBA:
deCombobox - sheet,1 cell, searchable,filter - example 1.xlsm

You can adjust the code in this part:

'=============== YOU MAY NEED TO ADJUST THE CODE IN THIS PART: ===================================

'sheet's name where the list (for combobox) is located. [in the sample: sheet "deList"]
Private Const sList As String = "deList"

'cell where the list start [in the sample: cell A2 in sheet "deList" ]
Private Const sCell As String = "A2"

'the linked cell
Private Const xCell As String = "B3"

And if you want a searchable combobox for multiple cells, here's an example:
best-way-to-create-a-searchable-drop-down-list-with-auto-complete-functionality-to-cells-in-a-column

Thank you Akuini,

This helped a bunch!

 

[Akuini]

You're welcome, glad to help, & thanks for the feedback.