I know there is a worksheet change event. Is there an event to run when a worksheet is change (say when a user clicks from tab A to tab B?)
In my senario, user would enter data on A and then switch to B to see calculated data (using some VBA)
How would I go on to do this?
Is it possible to do this via worksheet change event?