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" wrote in message
...
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" wrote in message ...
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.