Hi,
I don't know a lot about VBA but this should work for you.


If CheckBox1.Value = True Then
MsgBox "You must also submit the main contract", vbDefaultButton1
Else: Exit Sub
End If


insert this code into the checkbox code or into a macro.

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=478025