View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Dialog box in a macro

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
"cagey63" wrote:

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.