I would use

If Not Checkbox1.Value Then
If Not Checkbox2.Value Then
If Not Checkbox3.Value Then
Unload Me
End If
End If
End If

This way, if 1 or 2 is set, the remaining tests are not executed.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"abxy " wrote in message
...
How would i write in VB code:

if checkbox1, checkbox2, and checkbox3 all equal false then Unload me,
else finish going thru the rest of the code.

I just don't know how to 'ask' "if [multiple things] then" in VB

thanks


---
Message posted from http://www.ExcelForum.com/