Excel crash when trying to Autocomplete an ActiveX ComboBox
You are forcing Combobox's possible values to update when you change the selected option,
that is why it's crashing.
You can try to keep Me.ComboBox1.DropDown
in that event.
But the .ListFillRange
should be in another event :
- Workbook_Open
- Workbook_SheetChange
- Worksheet_SelectionChange
- Worksheet_Change
If you're attempting to have a kind of AutoComplete behavior, you can use a built-in property :
- Right-click on the Control, click on Properties
- In the opened Properties window, find the
MatchEntry
property - Set it to
0 - fmMatchEntryFirstLetter