Break point equivalent

[Don Wells]

    Is there a VBA Command equivalent that will act like a breakpoint? A breakpoint that doesn't disappear when the file is closed and reopened.
    I have been using a message box for tthis feature during code development; but when it fires I am unable to edit either the target document or the code while the code is stopped.

[Doc.AElstein]

Hello Don ..... easy one ....
Stop

Code: Select all

Sub StopIt()   '        Break point equivalent       https://eileenslounge.com/viewtopic.php?p=268543#p268543
' Doing stuff
' Doing stuff
'
 Stop          '       Breakpoint Command: The  Stop  Statement     You can place Stop statements anywhere in procedures to suspend execution. Using the Stop statement is similar to setting a breakpoint in the code. The Stop statement suspends execution, but unlike End, it doesn't close any files or clear variables, unless it is in a compiled executable (.exe) file.                                            https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/stop-statement                                                                     Hi there, nice to see you here in this nice peacefull place. Hope you are well!  :)
'  Carry on after this from the VB Editor with a run ( F5 key )  or  carry on in step mode with key  F8
End Sub

( Stop statement )

Alan

[HansV]

You might also like Debug.Assert. It acts like a conditional breakpoint. The syntax is

Code: Select all

    Debug.Assert condition

The code will continue to run as long as condition evaluates to True, but it will pause when condition evaluates to False.

Example:

Code: Select all

Sub Test()
    Dim a As Long
    Dim b As Long
    a = 5
    For b = 1 To 10
        ' Some code here
        ' ...
        Debug.Assert b <> a
    Next b
End Sub

When you run the Test macro, it will pause when b = 5, for then the condition b <> a is NOT true.

[Don Wells]

Thank you Alan and Hans. Just what I wanted.