I have the below code. It runs when I change the contents in G1 manually (or Edit and then Enter the cell). However, I just want an equation in G1 which receives different values from another area in the worksheet, and I want it to run when a value changes in G1 from a different value passed to it.
Can anyone help?
Please Login or Register to view this content.
Last edited by pglufkin; 12-13-2013 at 02:18 PM.
Can you please fix the code tabsThanksHTML Code:
Hi pglufkin
Sheet Change Event Code does not fire when a Cell is changed by Formula...monitor a Cell that's causing G1 to change.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
ok, thx, got it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks