STOP Statement

  • It enables the application to provide the BREAK POINT programatically

    •  

  • Normally user provides Break point by mentioning F9, instead of human intervention user can provide the Break point programatically

    •  

     

    Download The Workbook

     

     

    Sub Provide_BreakPoint_Programatically()
    Range("A1").CurrentRegion.Clear
    Dim i As Integer
    For i = 1 To 11
    If i = 5 Then
    Stop
    End If
    Cells(i, 1).Value = i
    Next
    End Sub

     

Hi Everyone,
Welcome to VBA Macros Tutorial. This Tutorial provides comprehensive knowledge on VBA Macros to the user. Hope it enhances your coding skills. If you like this web page kindly Share this to your near and dear. I Prepared this content as per my level of knowledge, if any changes required kindly bring to my notice. Thanks for visiting this web page

Thanks,
Pavan Kumar Gundlapalli