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