Protect ComboBox Lidt

M

Minitman

Greetings,

I have a ComboBox on a UserForm. I need the user to be able to choose
a name from the ComboBox list but not be able to add to or modify this
list.

Anyone know how this is done?

Any help would be appreciated.

-Minitman
 
I

Incidental

Hi Minitman

Change the style property to fmStyleDropDownList.

Hope this helps

Steve
 
M

Minitman

Hey Steve,

Thanks for reply.

That did indeed do the trick - Thank you.

-Minitman
 
Top