you want a If Then statement...

Sub Test()

If Checkbox1.Value = True Then
'code to use if checkbox is checked...
Else:
'code to use if checkbox is unchecked...
End If
End Sub


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=533516