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

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.

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

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

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

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

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

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

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

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


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=548610