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