Forcing Combo box entry in VBA

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box 2
hide combo box 6
Combo box corrupting VLookup function 1
Combo box VBA error 5
Appearance of Data Validation Combo Box 2
Link combo box selection to a cell 1
List box or Combo box?? 1
Validation list in data entry form 4

Top