View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Moose[_2_] Moose[_2_] is offline
external usenet poster
 
Posts: 4
Default "If Yes then Proceed..." Macro


bman342 wrote:
I need a simple Yes/No dialog box.
If the User clicks "Yes" it runs a macro that I have already recorded.
If "No" it closes the macro.

Is there a trusted public library of these types of basic macros somewhere?

Thanks so much.


Try This:

Msg = MsgBox("Your Question For User",vbYesNo,)
If Msg = vbNo Then Exist Sub
If Msg = vbYes Then Your Macro