Trying to run macro based on checkbox selection

[caliskier]

Hi, the following code is in "ThisWorkbook"

Please Login or Register  to view this content.

The code at the very top that says

Please Login or Register  to view this content.

is really part of the bottom half of the code reprinted below

Please Login or Register  to view this content.

The top half works fine. The Top and Bottom are completely seperate code that have nothing to do with each other. I want the bottom half only to function if checkbox1 is checked. This check box is on a sheet called "Checklist" I just can't figure out how do do this, can anyone help?

[Leith Ross]

Hello caliskier,

You need to isolate the macro in a Standard VBA module so that it is available to the entire project. It would help to have a better description of what you want to achieve. It isn't clear why you have all this code in the ThisWorkbook events.

Once you have the macro in the Standard module you can attach it to a Forms check box, or call it from the Click event of a Control Toolbox check box.

Sincerely,
Leith Ross