Combo Box Query

[MrGJEB]

Hi,

I am using a combo box on a userform that is linked to a range in my worksheet.

Currently the user can type what ever they want into the combo box, even if it is not in my range.

How can i validate the combo box so that the user is only able to select an entry from the drop down list i.e my range.

many thanks

 

[pike]

MrGJEB

In the combbox properties change the "Style" property from combobox 0 to list 2

pike

 

[mikerickson]

Set the .MatchEntry propery to fmMatchEntryComplete and the .MatchRequired to True.

 

[MrGJEB]

Many Thanks