abxy

try something like this

with userform1
if .checkbox1 and .checkbox2 and .checkbox3 = False then
unload me
exit sub ''this stops the macro
end if
end with

HTH

Charle

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