"If Yes then Proceed..." Macro
Works fine. Much thanks to both.
"Norman Jones" wrote:
Hi Bman342,
Alternatively, try:
'=============
Public Sub Tester()
Dim res As VbMsgBoxResult
res = MsgBox(Prompt:="Do you wish to run the Macro?", _
Buttons:=vbYesNo + vbQuestion)
If res = vbYes Then
Call myMacro
End If
End Sub
'<<=============
---
Regards,
Norman
"bman342" wrote in message
...
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.
|