form check box
 

how do i reference a forms check box in a formula (whether it is checked or
not)

thanks

form check box
 

In vba use

Sub CheckBox1_Click()

If checkbox3 = "False" Then

MsgBox "Unchecked "
Else
MsgBox "Checked "
End If
End Sub

if you want to detect its state in a worksheet formula then format the
control with a linked cell. If you do this the cell will display True for
checked ir false for unchecked which you can reference with your formula.

"sako 338" wrote:

how do i reference a forms check box in a formula (whether it is checked or
not)

thanks