Hello

I have the following piece of code in Excel sheet 1 to trigger an event when
a cell content changes

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$4" Then
'This Code Runs When Cell A4 Changes'
End If
End Sub

What I want to do is insert here code to interrupt the running of a
particular userform and goto a particular point and resume that same
userform.

So something like

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$4" Then
userform1.stop
goto userform 1line 220
userform1.resume
End If
End Sub

Except obviously I'm making up the code here. Could anyone advise on what
the correct code might be for such an operation.

Many thanks