View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Run a macro when cell changes (due to calculation!)

You might try using a worksheet calculate event and if it doesn't calculate
on the formula change, add =Now() somewhere on the worksheet.

--
Don Guillett
SalesAid Software

"Tornados" wrote in message
...
Goodday,

I tried to use the worksheet change functions, yet they only seem to
act when you actively enter into a certain cell.

However i need to call a certain macro when the output in a certain
cell changes due to the change in the specific if function. Therefore
without user intervention.

Is there any way to do this?

Kind regards,

Ivo Geijsen


---
Message posted from
http://www.ExcelForum.com/