Confirmation message in VBA

[Gkn1]

how can I ask the user for confirmation before running Excel macros in VBA?​

 

[AC PORTA VIA]

Add below at the begining of your macro

If MsgBox("Do you wish to continue? ", vbYesNo) = vbYes Then
        ' rest of your macro
    Else
        
        Exit Sub
    End If

 

[Gkn1]

thank you