Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In the userform code area, use the userform_initialize sub with code
like this: CheckBox1.Value = False In the CheckBox1_Change Event use code like this: TextBox1.Enabled = Not(CheckBox1.Value) TextBox3.Enabled = Not(CheckBox1.Value) HTH Charles Jacob wrote: I have created a program using VBA and I am attempting to use a form for my first time. I want to have a checkbox that when checked allows users to input additional items into the form. by default I want the box to be unchecked and those input boxes grayed out and disabled. what is the best way to do this? thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
activate/deactivate macro depending on who's the user | Excel Discussion (Misc queries) | |||
Links is in gray color (deactivate). How can I activate? | Excel Discussion (Misc queries) | |||
Activate/deactivate Office Clipboard in VBA | Excel Programming | |||
activate/deactivate button with macro at given condition | Excel Programming | |||
Activate / Deactivate mouse move event | Excel Programming |