I have a ActiveX checkbox I created from the Developer/Insert Menu. In VBA, I would like to see if the check box is checked and if it is run a certain code and if it is not checked run another section of code. The checkbox is located in the PA_Running_Sheet_A worksheet in cell C17. When I check that box I get an error message. Does anyone know what I am doing wrong?
My code is in Sheet2 and the error messages says Complie error: Expected Function or Variable
Thanks
redsab
Bookmarks