ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Protect ComboBox Lidt (https://www.excelbanter.com/excel-programming/416401-protect-combobox-lidt.html)

Minitman

Protect ComboBox Lidt
 
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

Incidental

Protect ComboBox Lidt
 
Hi Minitman

Change the style property to fmStyleDropDownList.

Hope this helps

Steve


Minitman

Protect ComboBox Lidt
 
Hey Steve,

Thanks for reply.

That did indeed do the trick - Thank you.

-Minitman

On Tue, 2 Sep 2008 04:48:49 -0700 (PDT), Incidental
wrote:

Hi Minitman

Change the style property to fmStyleDropDownList.

Hope this helps

Steve




All times are GMT +1. The time now is 04:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com