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