MsgBox only after all selected Macros are run?

[Nola111]

Right now I have 12 Macros called GenerateData1, GenerateData2, etc, and then a 13th which just calls 1 through 12 contiguously. I have separate checkboxes for all 13 macros and any combination can be checked and run.

I'd like to give a Message Box that says Operation Complete but only after the last selected macro has finished running. Right now I have MsgBox "Operation Complete" at the end of each Macro, which works fine if the user only runs one macro at a time. How do I make a conditional MsgBox such that it only appears after the last macro completes?

Thanks.

[ranman256]

Run 1 macro that scans and runs any macros checked in the list...

Please Login or Register  to view this content.

[Nola111]

Run 1 macro that scans and runs any macros checked in the list...

Please Login or Register  to view this content.

Ranman, thanks for the reply. But I'm not sure I follow this solution. I have several Active X checkboxes each assigned to their own separate macro. I thought the solution to this might be something at the end of each macro that says IF <this is the last macro being run in the series> display the MsgBox, Else run the next macro in the series.

Will this ActiveCell.Value work in this case?

[ranman256]

Sorry,..didnt know...the activeX check boxes work different from the (easier) Form control check box.
The form control will mark a cell true/false and you can just scan cells w the code I gave.
The ActiveX version you must scan thru all objects..

(pseudo code)
for each ctl in controls
if ctl.type = checkbox then
if ctl.value then

[Nola111]

Sorry,..didnt know...the activeX check boxes work different from the (easier) Form control check box.
The form control will mark a cell true/false and you can just scan cells w the code I gave.
The ActiveX version you must scan thru all objects..

(pseudo code)
for each ctl in controls
if ctl.type = checkbox then
if ctl.value then

Ranman, thanks again for your reply.

I must admit my novice in VBA - while I feel I've learned a lot, I'm still a little confused as to the syntax I should use with the code you've provided. I'm trying to mesh together the code you've provided in your 2 posts then figure out where to put it. Should this code be placed in the sheet that the checkboxes reside in? Or appended to each of my macros? Not sure here.

Thanks again.