| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combox Help!
Hi,
Using MS Excel 2003 - VBA. I have a combox with a list of states. How can I prevent the user from entering a manual item into that list? I only want them to select the states I have populated into the list. I couldn't find a "Limit to List" property. :-( |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combox Help!
Hi,
In design mode right click it and 'Properties' and change the style property to frmStyleDropDownList Mike "PumaMan" wrote: Hi, Using MS Excel 2003 - VBA. I have a combox with a list of states. How can I prevent the user from entering a manual item into that list? I only want them to select the states I have populated into the list. I couldn't find a "Limit to List" property. :-( |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combox Help!
May God bless you and your family for 5 generations!!!!!!!!!!!!!!!!!!!!!
Thanks! :-) "Mike H" wrote: Hi, In design mode right click it and 'Properties' and change the style property to frmStyleDropDownList Mike "PumaMan" wrote: Hi, Using MS Excel 2003 - VBA. I have a combox with a list of states. How can I prevent the user from entering a manual item into that list? I only want them to select the states I have populated into the list. I couldn't find a "Limit to List" property. :-( |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combox In Form | Excel Programming | |||
| combox question | Excel Programming | |||
| Combox Box and 3 worksheets | Excel Programming | |||
| Combox Box and 3 worksheets | Excel Programming | |||
| Combox Locking | Excel Discussion (Misc queries) | |||
Linear Mode
