I am trying to write a macro that will change the font color of a cell if the cells value has changed. I can get it to work for cells that are manually changed but I need it to work when the value changes in a cell that has a formula populating that cell with data from another sheet. Any help is greatly appreciated!
You will probably have to use Private Sub Worksheet_Calculate() and set calculation to automatic to get it to respond to values changed by formula since Excel ignores changes resulting from calculations in the Worksheet_Change event.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
JLGWhiz,
I did try using Private Sub Worksheet_Calculate() but ovbiously did not do something correct and am looking for help to solve.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks