Is this possible: whenever the value of a cell changes that value and the time of the change is recorded?
For instance, if cell A1 begins with a value of 5, then changes to 4, that new value is recorded:
(4, 10/26/2011 1:42am)
...
and so forth.
The changes would be as the result of a DDE link; not a user typing into a cell. Thanks for any help!
Greg
It can be done, but it's not easy (at least not for me).
Try this to get you started:
Then run "StartCheckValues" to start checking and "StopCheckValues" to stop checking.
Please Login or Register to view this content.
If you want to always be running when the workbook is open then put "StartCheckValues" in Workbook_Open()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks