Searchable dropdown list with combo box

[Bagsy]

Hi I have run into a problem, I hope somebody can help me out a bit. I have a dropdown list in D7 on a sheet called cost sheet, with the data on another sheet called data, (this is in column B4:B106),in a table but obviously automatically updates as new rows are added to the table.

I have created the formulas within the table and added the combo box on the cost sheet , but when I type in the combo box it only suggests the first example and prefills into cell D7 instead of listing all the items that meet the search criteria.

Eg

If I type pad into the combo box I only get this (Pad 100121602-AF type I, round seal PDX8) this is the first pad on the list

This shows up as this on my data sheet as

If I then delete 100121602-AF type I, round seal PDX8 from the Combo box so I am just left with pad, it will then list all the pads in the combo box & on the data sheet.

Obviously if I type pad into the combo box I want it to list all the pads instead of selecting the first one from the list, I am unsure what I have done wrong
Any help would be very much appreciated

 

[davesexcel]

Is the combobox coded?

 

[Akuini]

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

If you want a searchable combobox in multiple cells, you can find an example here:
best-way-to-create-a-searchable-drop-down-list-with-auto-complete-functionality-to-cells-in-a-column

If you're interested, I can help you set it up on your file.

 

[Bagsy]

Hi Dave
thanks for your help, the only cdode on the combo box is
Private Sub ComboBox1_Change()
ComboBox1.DropDown
End Sub

 

[Bagsy]

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

If you want a searchable combobox in multiple cells, you can find an example here:
best-way-to-create-a-searchable-drop-down-list-with-auto-complete-functionality-to-cells-in-a-column

If you're interested, I can help you set it up on your file.

Thanks Akuini
That is awesome I have adjusted the code to sort my needs and its brilliant, Just a quick question, can you change the properties of the combo box so the drop down list is larger with bigger text

 

[Akuini]

can you change the properties of the combo box so the drop down list is larger with bigger text

Which combobox are you reffering to? the first one or the second one?

 

[Bagsy]

Akuini
It was the first one using a single cell
I have sorted the properties of the combo box to make the font larger, a bit of trial & error
Thank you so much for your help.

 

[Akuini]

I have sorted the properties of the combo box to make the font larger, a bit of trial & error

OK, glad you figured it out.
You're welcome, glad to help, & thanks for the feedback.