| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
"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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display last entry in Excel | Charts and Charting in Excel | |||
| combo chart conversion | Charts and Charting in Excel | |||
| Double combo charts - are they possible? | Charts and Charting in Excel | |||
| Selected cells grow and data entry impossible EXT is dissabled | Excel Discussion (Misc queries) | |||
| Linking Combo box to pivot table? | Excel Discussion (Misc queries) | |||
Linear Mode
