VBA Code - Call a macro and stop the run until certain lines

[Johns90]

Hi,

I have a Macro (the name is Test() ) from the Module1, and normally to call this Macro, i am using the code :
Call Module1.Test

But i am looking to a VBA code to call my Macro Test from Module1 until certain lines of code
Example stop the runing when the macro is arriving to the line 900

Thanks for your help

 

[JGordon11]

Not sure how to do what you're asking for (not sure it's possible).

But here's an approach to stop a code early based on a passed parameter:

Option Explicit

Sub Test(Optional StopEarly As Boolean = False)
    Dim i As Long
    For i = 1 To 10
        If StopEarly And i > 5 Then
            MsgBox i
            Exit Sub
        End If
    Next
    MsgBox i
End Sub

Sub CallTest()
    Test         'msgbox displays 11
    Test True    'msgbox displays 6
    Test False   'msgbox displays 11
End Sub