Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to add Restrictions to Combo Box?/
Hello,
I'm relatively new to VBA. My problem is I have created a combo box and I want the user to be restricted to the drop down selection only. Example. If the user has options of choosing from A, B, C and D...I want to restrict the user to these options only. Currently the user can enter any Value and that gets recorded... I'm using VBA userforms for Combo Box... Any help is appreciated... Thanks... Balaji.. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to add Restrictions to Combo Box?/
Rightclick on the combobox (while in design mode).
Select properties scroll to Style and change that to fmStyleDropDownList Balazee wrote: Hello, I'm relatively new to VBA. My problem is I have created a combo box and I want the user to be restricted to the drop down selection only. Example. If the user has options of choosing from A, B, C and D...I want to restrict the user to these options only. Currently the user can enter any Value and that gets recorded... I'm using VBA userforms for Combo Box... Any help is appreciated... Thanks... Balaji.. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro that can run combo boxes | Excel Discussion (Misc queries) | |||
Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
Dynamic Combo Box | Excel Worksheet Functions | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions |