Combox Locking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
If you don't want the user to change this, why use a combobox?

Why not just a label?
 
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
 
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

Userform w/ComboBox 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Enter text in a Combobox 2
entering time values 1
Show Filename Only in ComboBox Pulldown 16
How to Display Arrow for Drop Down Lists in Message Body 0
Re-show userform after closing file - code help 3
.AddItem list and populating combobox with created list 8

Back
Top