Hello,
I have a vba script that uses the Worksheet_SelectionChange(ByVal Target As Excel.Range) sub
in this sub I have multiple cells given a Target.Address if statement. like this.
When I go into a cell it will activate another sub somewhere. Then when I hit enter, or click in a different cell it would do something else.
Is there a way to put a check in each ElseIf section to see when I am exiting the cell, and run a sub on the way out?
Like
I've tried to search for something like that but was unable to find anything on leaving a target.address location.
I have a vba script that uses the Worksheet_SelectionChange(ByVal Target As Excel.Range) sub
in this sub I have multiple cells given a Target.Address if statement. like this.
VBA Code:
ElseIf Target.Address = "$F$21" Then
Call DCmVoltsSection
ElseIf Target.Address = "$F$22" Then
Call ACmVoltsSection
Is there a way to put a check in each ElseIf section to see when I am exiting the cell, and run a sub on the way out?
Like
VBA Code:
If onExit.Target.Address Then
do something
End IF