Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
binding checkboxes
Ok here is the issue, I want to have a checkbox that is
dependant on another checkbox. So if checkbox 1 is checked than checkbox 2 is active, if checkbox 1 is not checked then checkbos 2 is greyed out and isn't allowed to be checked. I found that there was a "bound" function in VBA but I don't know how to use it. please help! --Keri |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
binding checkboxes
The bind function refers to the data source for the
objects so you can also set this up to change the data source with a similar conditional statement. If you've bound the control to a data source, a valid change in VBA will change the source at the same time. Just set before enable/disable. Private Sub CheckBox1_Click() 'check1 on checked, check2 enabled If Me.CheckBox1.Value = True Then Me.CheckBox2.Enabled = true Else 'check1 not checked, check2 disabled If Me.CheckBox1.Value = False Then Me.CheckBox2.Enabled = False End If End If End Sub -----Original Message----- Ok here is the issue, I want to have a checkbox that is dependant on another checkbox. So if checkbox 1 is checked than checkbox 2 is active, if checkbox 1 is not checked then checkbos 2 is greyed out and isn't allowed to be checked. I found that there was a "bound" function in VBA but I don't know how to use it. please help! --Keri . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
binding checkboxes
Hi Keri,
Keri wrote: Ok here is the issue, I want to have a checkbox that is dependant on another checkbox. So if checkbox 1 is checked than checkbox 2 is active, if checkbox 1 is not checked then checkbos 2 is greyed out and isn't allowed to be checked. I found that there was a "bound" function in VBA but I don't know how to use it. please help! you can use this little Code: Private Sub CheckBox1_Click() CheckBox2.Enabled = CheckBox1.Value End Sub -- Regards Melanie Breden - Microsoft MVP für Excel - http://excel.codebooks.de (Das Excel-VBA Codebook) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Late Binding | Excel Programming | |||
Late Binding | Excel Programming | |||
XML Data Binding | Excel Programming | |||
EARLY binding or LATE binding ? | Excel Programming | |||
DAO Late Binding? | Excel Programming |