Forcing Combo box entry in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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

Appearance of Data Validation Combo Box 2
Combo Box/Drop down box 1
Graph linked with combo boxes 2
hide combo box 6
Logic within combo boxes? 2
Combo box VBA error 5
List box or Combo box?? 1
Combo Box that allows user entry of values not on drop-down list 1

Back
Top