Create a public array and set the items of the array to 1 or 0 depending
whether the checkbox is set or not, from the OK button, and read that array
in your main module.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ExcelMonkey" wrote in message
...
I have a form with 7 check boxes. The seventh is a Select
All with checks 1-6. Upon checking the desired boxes, the
user must press either OK or Cancel. Cancel exits the
sub. OK calls the main macro. I want to be able to pass
my check values (TRUE/FALSE) from my click event into the
main macro. Does this mean I have to pass them to the OK
click event and then once again to the main macro. How do
I do this?

Thanks