LinkBack URL
About LinkBacks
Can anyone advise what the main differences are between Private Sub Worksheet_Change(ByVal Target As Range) and Private Sub Worksheet_Calculate() and when the best scenario is to us each one?
Thanks in advance
Can anyone advise what the main differences are between Private Sub Worksheet_Change(ByVal Target As Range) and Private Sub Worksheet_Calculate() and when the best scenario is to us each one?
Thanks in advance
Hi,
They are both two macro procedures that 'fire' on specific events taking place.
The worksheet change procedure will fire whenever a cell on the worksheet changes. The worksheet calculate event when any cell calculates. You may feel they both do the same thing since changing a cell will mean a calculate will also take place if the cell you're changing has a formula. And indeed they'll both fire if that happens. But changing a cell that hasn't got a formula and no other cell is dependent on it will only fire he change event.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks for the good explanaion
Glad to have helped and thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks