Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Box
Hi,
I have a form with a checkbox and then two textboxes that are associated with the checkbox. So I want to make the checkboxes unshaded when the checkbox is selected and "shaded" when the checkbox is not checked. I have seen this before in forms. I tried using the "visible" property but this makes the entire box disappear, and I only want it "shadded" Has anyone done something like this before - do you know what property to use. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Box
Jeff,
Would this suffice? If so, you probably want to put the ELSE code in the Userform_Initialize routine. Private Sub CheckBox1_Click() If CheckBox1.Value = True Then TextBox1.Enabled = True TextBox2.Enabled = True TextBox1.BackColor = &H8000000F TextBox2.BackColor = &H8000000F Else TextBox1.Enabled = False TextBox2.Enabled = False TextBox1.BackColor = &H80000011 TextBox2.BackColor = &H80000011 End If End Sub "Jeff" wrote: Hi, I have a form with a checkbox and then two textboxes that are associated with the checkbox. So I want to make the checkboxes unshaded when the checkbox is selected and "shaded" when the checkbox is not checked. I have seen this before in forms. I tried using the "visible" property but this makes the entire box disappear, and I only want it "shadded" Has anyone done something like this before - do you know what property to use. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entry into check box dependent on other check box. | Excel Worksheet Functions | |||
Can you sort with check boxes? | Excel Discussion (Misc queries) | |||
check boxes - copy | Excel Discussion (Misc queries) | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
Creating a check box that does not require security clearance. | Excel Worksheet Functions |