View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Brown[_8_] Gary Brown[_8_] is offline
external usenet poster
 
Posts: 15
Default AFTER Calculate Event

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.