Forcing Combo box entry in VBA
 

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

"Anthony Slater" wrote in message
...
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?

ComboBox MatchRequired property set to true should do it.

Ian