Interactive Cancel Error

DaveK55

I am an inexperienced user trying to do some automation with macros.  I get an error if Cancel is selected on the Interactive Pop Up.  It works fine as just a Macro but if I put it in an App it errors out. 
Thanks,
Dave K.

PierreD

Hello Dave,

In your App, you have to use a Try/Catch block to handle the exception.

Pierre

    Public Sub button1_Click(sender As Object, e As System.EventArgs) Handles button1.Click
        Try
            TestInteractionMacro
        Catch
            'user clicked Cancel, exit macro
            Exit All
        Finally
        End Try
    End Sub

DaveK55

Merci Pierre!
Dave K.