ActiveX Combobox showing data incorrectly - last collapsed

[AlexExcel2021]

I have interesting trouble with ActiveX combobox placed on form. It collapse data for one row (please look to the screenshot) after I typ next char after first, if we click on Dropdown button - Combobox start showing data correctly agian. MatchEntry mode setup as none in my case. Can I prevent collapsed data to one row?

 

[DanteAmor]

Please check these solutions:

Autocomplete ActiveX combobox

I am trying to create an autocompleting ActiveX combobox and have managed to get it to work almost perfectly. Private Sub ComboBox1_Change() Call CreateCustomList Me.ComboBox1.DropDown End Sub Sub CreateCustomList Dim Val As String Val = Userform.ComboBox1.Value Dim...

www.mrexcel.com

Autocomplete ActiveX combobox

I am trying to create an autocompleting ActiveX combobox and have managed to get it to work almost perfectly. Private Sub ComboBox1_Change() Call CreateCustomList Me.ComboBox1.DropDown End Sub Sub CreateCustomList Dim Val As String Val = Userform.ComboBox1.Value Dim...

www.mrexcel.com

Searchable combobox in excel vba userform with time format

Hi- I have a combobox with rowsource in time format for example 10:00 AM .It has data with time at 5 minutes interval. I am looking for code with searchable combo box where if I type 10 it should drop down list starting from 10:00 AM I have tried all the codes from different sources available...

www.mrexcel.com

I hope it helps you.
.