Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combox Locking
Hello:
How do you lock the Combobox 'value' in a UserForm form beign changed by a user? I have tried setting Locked=True in the properties window, but when the UserForm is active, you cannot click on the drop down arrow to get to the item list. Is there a combination of properties I should be setting or something? Also, after a user has made a selection they can change the 'value' in the Combobox. How do I protect the 'values' in the Combobox window? Thank you for your assistance. Kind regards, D.Parker |
#2
|
|||
|
|||
If you don't want the user to change this, why use a combobox?
Why not just a label? D.Parker wrote: Hello: How do you lock the Combobox 'value' in a UserForm form beign changed by a user? I have tried setting Locked=True in the properties window, but when the UserForm is active, you cannot click on the drop down arrow to get to the item list. Is there a combination of properties I should be setting or something? Also, after a user has made a selection they can change the 'value' in the Combobox. How do I protect the 'values' in the Combobox window? Thank you for your assistance. Kind regards, D.Parker -- Dave Peterson |
#3
|
|||
|
|||
I need a ComboBox because the user needs to select one of a few options from
the pull down. Unfortunately once they select the option, they can change the 'value' if they so desire. Is there a way to protect against this while retaining the selection options? Kind regards, D.Parker "Dave Peterson" wrote: If you don't want the user to change this, why use a combobox? Why not just a label? D.Parker wrote: Hello: How do you lock the Combobox 'value' in a UserForm form beign changed by a user? I have tried setting Locked=True in the properties window, but when the UserForm is active, you cannot click on the drop down arrow to get to the item list. Is there a combination of properties I should be setting or something? Also, after a user has made a selection they can change the 'value' in the Combobox. How do I protect the 'values' in the Combobox window? Thank you for your assistance. Kind regards, D.Parker -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking a couple rows so when you do a delete shift row they dont | Excel Discussion (Misc queries) | |||
Locking formula for a Sort | Excel Discussion (Misc queries) | |||
Locking a personal folder on a shared drive | Excel Discussion (Misc queries) | |||
Locking certain cells | Excel Worksheet Functions | |||
locking the scroll? | Excel Worksheet Functions |