Dialog box in a macro

[cagey63]

While executing a macro, I want to first show a form or message box
providing information to the user and allow continuation or
cancellation of the macro dependent upon the user's decision. I've
got the macro built and functioning but I'm unsure of the best way to
execute this additional step.

Thanks for the help.

 

[FSt1]

hi
a yes/no message box inclosed in an if statement might work.

If MsgBox("entery message here", vbyesno) = vbYes Then
Exit Sub
End If

if the user select yes, code stops otherwise it will continue.

regards
FSt1