Is there a way to put a macro or vb code on a Sheet's code that will
automatically run when there is a change in the sheet. I tried to put code
by itself but it gave me an error message saying "Invalid Outside Procedure".
Thanks for your help.
Is there a way to put a macro or vb code on a Sheet's code that will
automatically run when there is a change in the sheet. I tried to put code
by itself but it gave me an error message saying "Invalid Outside Procedure".
Thanks for your help.
Good evening Steven
When you say "a change in the sheet" do you mean when the sheet is changed or when the user changes sheets? If the former, which I suspect, try this, inserted in the relevant sheet's code section.
Private Sub Worksheet_Change(ByVal Target As Range)
' Your code can go in here
End Sub
Your macro would then trigger every time that particular sheet is changed.
HTH
DominicB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks