View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Eileen[_3_] Eileen[_3_] is offline
external usenet poster
 
Posts: 2
Default Quick VBA code question (if...then statement)

If checkbox1.value = false and checkbox2.value = false and
checkbox3.value = false then
unload me
End If

If all the criteria isn't met, the "unload me" will be
skipped and the code following the "end If" will execute.

-----Original 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/

.