I'm sure this will be obvious to most but I am slightly confused by the Worksheet change event concept.
Please Login or Register to view this content.
If I enter value in A1 event triggers but how would you get the change event to trigger if say A1 gets its value from a formula, say the result of user changing values in B1
Hello coasterman,
This is a paradox. The Worksheet_Change only executes if a cell has been changed by the user or by code. It is not triggered when a cell value is changed as the result of a formula. There is no reliable way to know when cell has been updated by a formula.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks