View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey[_190_] ExcelMonkey[_190_] is offline
external usenet poster
 
Posts: 172
Default Passing CheckBox Value from Click Event to Main Macro

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