Is there a way in VBA to be notified when a cell has changed with the row and column number and the cell contents?
I am hoping for some event to be fired, but if not I can keep checking a changed flag if that is what it takes.
Thanks,
Bob Hiller
Is there a way in VBA to be notified when a cell has changed with the row and column number and the cell contents?
I am hoping for some event to be fired, but if not I can keep checking a changed flag if that is what it takes.
Thanks,
Bob Hiller
Hello excelbobabc,
There are 2 worksheet events: Change and SelectionChange. Chage fires whenever the contents of cell change and SelectionChange whenever the user clicks on cell.
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 Star below 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)
Bookmarks