Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox activate Combobox selection
I have a checkbox that when checked I want the user to select from a combobox
and not by-pass until selection has been made. Any suggestions. Not realy a VBA programmer. Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox activate Combobox selection
There are 2 standard ways to tell if a userform has been completed properly.
Method 1 OK/Continue Button is disabled - in this method the user fills in all of the available controls. Each control's change event triggers a macro that verifies if all the required fields are filled and enables or disables the OK/Continue button. I use this a lot. Method 2 OK/Continue Button is always enabled - in this method the user fills in all of the available controls and clicks on the OK/Continue button. The OK/Continue button triggers a macro that verifies if all the required fields are filled properly and alerts the user if any field is not filled properly. I want to use this method more. "LRay67" wrote in message ... I have a checkbox that when checked I want the user to select from a combobox and not by-pass until selection has been made. Any suggestions. Not realy a VBA programmer. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
How do I activate a worksheet using a checkbox when it is checked? | Excel Programming | |||
Using a checkbox to activate/deactivate input option | Excel Programming | |||
Combobox items determined by the selection in another combobox | Excel Programming | |||
How can I activate a combobox by keyboard strokes ? | Excel Programming |