you need to double click the box and give it some code to perform should
it be checked for example
if you make a FORM - check box
you need it to right click and format control and give a cell link
value.
so lets say you asign A1 to it the you will notice a1 will = true or
flase depending on the check or uncheck then you could write a formula
saying
=if(A1=true,"check box is checked","check box is unchecked")
if you make a control toolbox xhexk box
double click it and asign some code
example
Private Sub CheckBox1_Click()
If CheckBox1 = True Then
Range("A2") = "checked"
Else
Range("a2") = "unchecked"
End If
End Sub
hope this helps
--
Zygan
------------------------------------------------------------------------
Zygan's Profile:
http://www.excelforum.com/member.php...o&userid=34423
View this thread:
http://www.excelforum.com/showthread...hreadid=559515