| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protect ComboBox Lidt
Hi Minitman
Change the style property to fmStyleDropDownList. Hope this helps Steve |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can protect worksheet then workbook but not Protect and Share in code | Excel Programming | |||
| I need a way to password protect a combobox? | Excel Programming | |||
| Combobox options based on the input of another combobox | Excel Programming | |||
| ComboBox list reliant on the entry from a different ComboBox | Excel Programming | |||
| How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
Linear Mode
