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

[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.

[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

[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

[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?

"Bearacade" wrote:

>
> 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
>
>
> --
> Bearacade
> ------------------------------------------------------------------------
> Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
> View this thread: http://www.excelforum.com/showthread...hreadid=548610
>
>

[Bearacade]

Goto View, Toolbars, Control Toolbox

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

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