Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clickbox control help needed
I would am attempting to create two clickboxes where when one is
turned On the other is turned Off automatically. No luck so far. Any suggestions would be appreciated. Below are two of the codes I have tried. Private Sub CheckBox1_Click() CheckBox1.Value = True CheckBox2.Value = False End Sub Private Sub CheckBox2_Click() CheckBox2.Value = True CheckBox1.Value = False End Sub AND Private Sub CheckBox1_Click() If CheckBox2.Value = True Then CheckBox2.Value = False End If End Sub Private Sub CheckBox2_Click() If CheckBox1.Value = True Then CheckBox1.Value = False End If End Sub TIA, BrianG |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clickbox control help needed
Why not use radio buttons (small circles) as they are designed specifically
to be mutually exclusive (only one can be selected at a time). -- HTH... Jim Thomlinson "BrianG" wrote: I would am attempting to create two clickboxes where when one is turned On the other is turned Off automatically. No luck so far. Any suggestions would be appreciated. Below are two of the codes I have tried. Private Sub CheckBox1_Click() CheckBox1.Value = True CheckBox2.Value = False End Sub Private Sub CheckBox2_Click() CheckBox2.Value = True CheckBox1.Value = False End Sub AND Private Sub CheckBox1_Click() If CheckBox2.Value = True Then CheckBox2.Value = False End If End Sub Private Sub CheckBox2_Click() If CheckBox1.Value = True Then CheckBox1.Value = False End If End Sub TIA, BrianG |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clickbox control help needed
I'm trying to use clickboxes because the look of the clickbox on the
printed form is preferable to that of the radio button. Of course, if I can't control the clickboxes I'll need to consider other options. BrianG |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clickbox control help needed
You can try this...
Private Sub CheckBox1_Click() If CheckBox1.Value = True Then CheckBox2.Value = False CheckBox3.Value = False End If End Sub Private Sub CheckBox2_Click() If CheckBox2.Value = True Then CheckBox1.Value = False CheckBox3.Value = False End If End Sub Private Sub CheckBox3_Click() If CheckBox3.Value = True Then CheckBox1.Value = False CheckBox2.Value = False End If End Sub -- HTH... Jim Thomlinson "BrianG" wrote: I'm trying to use clickboxes because the look of the clickbox on the printed form is preferable to that of the radio button. Of course, if I can't control the clickboxes I'll need to consider other options. BrianG |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clickbox control help needed
That did it. Many thanks Jim.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Special Control Needed - Please Advise | Excel Programming | |||
Help needed with a RefEdit control | Excel Programming | |||
Programatically control picture property of Image control | Excel Programming | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming |