Calculations And Order In Macros

[Carl Bowman]

I have a macro that prints a message to the user, then calculates hundreds of
links (several minutes), then needs to clear the message. The macro is
basically, "print message, calculate, clear message". Will Excel wait until
it finishes updating the links before going to the next step in the macro to
clear the message? I cannot use the "wait" or "OnTime" command because there
is no way to predict how long the calculation will take.
Thanks.

[Otto Moehrbach]

You say "print the message" and you say "clear the message". Do you have a
message that is being sent to the printer or do you have a message box pop
up on the screen? If you have a message box (using the MsgBox command) pop
up on the screen, all code execution will stop until you click the OK button
in that message box. IOW, the code to "calculate" will not run until the
message box has been manually cleared. Does this help? Otto
"Carl Bowman" <[email protected]> wrote in message
news:[email protected]...
>I have a macro that prints a message to the user, then calculates hundreds
>of
> links (several minutes), then needs to clear the message. The macro is
> basically, "print message, calculate, clear message". Will Excel wait
> until
> it finishes updating the links before going to the next step in the macro
> to
> clear the message? I cannot use the "wait" or "OnTime" command because
> there
> is no way to predict how long the calculation will take.
> Thanks.

[Carl Bowman]

Thanks but your answer did not answer the question because I failed to give
you enough information. I am inserting a message to the user in one of the
cells, then recalculating the workbook, then clearing the message by clearing
the cell.
Thanks again.

"Otto Moehrbach" wrote:

> You say "print the message" and you say "clear the message". Do you have a
> message that is being sent to the printer or do you have a message box pop
> up on the screen? If you have a message box (using the MsgBox command) pop
> up on the screen, all code execution will stop until you click the OK button
> in that message box. IOW, the code to "calculate" will not run until the
> message box has been manually cleared. Does this help? Otto
> "Carl Bowman" <[email protected]> wrote in message
> news:[email protected]...
> >I have a macro that prints a message to the user, then calculates hundreds
> >of
> > links (several minutes), then needs to clear the message. The macro is
> > basically, "print message, calculate, clear message". Will Excel wait
> > until
> > it finishes updating the links before going to the next step in the macro
> > to
> > clear the message? I cannot use the "wait" or "OnTime" command because
> > there
> > is no way to predict how long the calculation will take.
> > Thanks.
>
>
>

[Otto Moehrbach]

Carl
The code works in the sequence it is written. It executes one line of
code, then moves on to the next line, and so on. It doesn't skip lines or
jump around in the code unless the code is written specifically to do so.
HTH Otto
"Carl Bowman" <[email protected]> wrote in message
news:[email protected]...
>I have a macro that prints a message to the user, then calculates hundreds
>of
> links (several minutes), then needs to clear the message. The macro is
> basically, "print message, calculate, clear message". Will Excel wait
> until
> it finishes updating the links before going to the next step in the macro
> to
> clear the message? I cannot use the "wait" or "OnTime" command because
> there
> is no way to predict how long the calculation will take.
> Thanks.

[Carl Bowman]

Thanks for the help. That was what I needed to know.

"Carl Bowman" wrote:

> I have a macro that prints a message to the user, then calculates hundreds of
> links (several minutes), then needs to clear the message. The macro is
> basically, "print message, calculate, clear message". Will Excel wait until
> it finishes updating the links before going to the next step in the macro to
> clear the message? I cannot use the "wait" or "OnTime" command because there
> is no way to predict how long the calculation will take.
> Thanks.