click/unclick a box and make other info. appear?

K

kOSUgirl7

I am trying to make it to where I click a box and then it has other
information appear, as to whatever I click. Kind of like a flow chart.
 
B

Bearacade

Maybe this will help:

Private Sub CheckBox1_Click()

If CheckBox1.Value = True Then
Range("A1").Value = "This check box has been checked"
Else
Range("A1").Value = "This check box has been unchecked"
End If

End Sub
 
B

Bearacade

Here is another option

Private Sub CheckBox1_Click()

If CheckBox1.Value = True Then
CheckBox1.Caption = "This Checkbox has been checked"
Else: CheckBox1.Caption = "This Checkbox has been unchecked"
End If

End Sub
 
K

kOSUgirl7

I'm really new at this, but if I get the checkbox from the forms section, I
don't know how to add the code in there. However, if I get it from the
control toolbox, I can edit the code, but am not able to click/unclick it?
Any suggestions there?
 
B

Bearacade

Goto View, Toolbars, Control Toolbox

Design Mode is the toggle, If you are in Design mode, you can go int
the code and stuff.

When you are out of it. You can "click" i
 
Top