AFTER Calculate Event

After my worksheets have been calculated, I need to display a message box
with particular information.

Went to the VBA code sheet for my worksheets, but there is no AFTERCalculate
event listed.

I know sometimes not all events are listed, IS there a aftercalculate event
available for me to use (either worksheet or workbook level).

Tanx.

John,

As far as I know there is no 'AfterCalculate' event.

Why not calculate the worksheet then have your processing code immediately
after that? That way you ensure that the worksheet has been calculated
prior to your code running. For example...

Calculate
your code here

Hope that helps,
Gary Brown



"PosseJohn" <PosseJohn@discussions.microsoft.com> wrote in message
news:D6288FE2-4A5D-4F2A-8A52-D27878D820E6@microsoft.com...
> After my worksheets have been calculated, I need to display a message box
> with particular information.
>
> Went to the VBA code sheet for my worksheets, but there is no
> AFTERCalculate
> event listed.
>
> I know sometimes not all events are listed, IS there a aftercalculate
> event
> available for me to use (either worksheet or workbook level).
>
> Tanx.

but there is a

Worksheet_Calculate Event (#calculate)
http://www.mvps.org/dmcritchie/excel....htm#calculate

and if you use a message box after every recalculation you
won't get anything done.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"PosseJohn" <PosseJohn@discussions.microsoft.com> wrote in message news:D6288FE2-4A5D-4F2A-8A52-D27878D820E6@microsoft.com...
> After my worksheets have been calculated, I need to display a message box
> with particular information.
>
> Went to the VBA code sheet for my worksheets, but there is no AFTERCalculate
> event listed.
>
> I know sometimes not all events are listed, IS there a aftercalculate event
> available for me to use (either worksheet or workbook level).
>
> Tanx.

"Calculate" is set to manual for the workbook. I'll check this out.

The calculation is being initiated manually, not by code.