Yes or No Box then run macro
Sub MyQuestion()
If MsgBox("Yes or No?", vbYesNo + vbQuestion) < vbYes Then
MsgBox "No Macro"
Else
MsgBox "Yes Macro"
End If
End Sub
" wrote:
Hi
I have two macros,
I want to run a macro based on whether the user clicks yes to a
question or no to a question,
I do not know how to make this message popup on screen,
Can someone help?
Thanks
Andrea
|