Locking a ComboBox for entry

[cs1ctp]

Hi,

I have implemented a ComboBox into a UserForm and was wondering if there is any way of only allowing the user to select a value from the drop down menu i.e. not letting them type there own values. I tried the "locked" property, but this locks the ComboBox completely.

Many Thanks in advance for your help,

Chris

 

[Juan Pablo González]

Change the 'style' property to fmStyleDropDownList