Thread
:
Run a macro when cell changes (due to calculation!)
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
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/
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]