Forcing Combo box entry in VBA

A

Anthony Slater

In my user form, I have several combo boxes that take their source from
various named ranges.

The drop down lists work fine but at the moment, a user is able to overwrite
whats in the dropdown.

How can I ensure that only what is in the drop down is chosen?

TIA
 
I

IC

Anthony Slater said:
In my user form, I have several combo boxes that take their source from
various named ranges.

The drop down lists work fine but at the moment, a user is able to overwrite
whats in the dropdown.

How can I ensure that only what is in the drop down is chosen?
Click to expand...

ComboBox MatchRequired property set to true should do it.

Ian
 
Top