Running a macro if msgbox is yes

T

Todd Huttenstine

Below is a message box popup I have in a code. I have a
macro called "emailnow". What I would like is if the user
clicks yes when the messagebox pops up, the code run
macro "emailnow". If the user clicks no, the sub will end.


If MsgBox("Email Agents now?. Do you want to continue?",
vbYesNo) = vbNo Then
Exit Sub
End If



Can anyone tell me how to do this?

Thanx

Todd Huttenstine
 
C

Chip Pearson

Todd,

Try something like


If MsgBox("Email Agents now?. Do you want to continue?", vbYesNo) = vbNo
Then
Exit Sub
End If
EmailNow

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
T

Todd Huttenstine

well that was easy. Thank you.

-----Original Message-----
Todd,

Try something like


If MsgBox("Email Agents now?. Do you want to continue?", vbYesNo) = vbNo
Then
Exit Sub
End If
EmailNow

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Remove Identical words 0
WORD VBA Search and switch to advanced ... 1
Prompt For Replace in Selection And More... 0
VBA Coding Help for Beginner 0
MsgBox; if 10-seconds, assumed 'No' Clicked 3
Continue macro from current workbook 0
Compile Error:Variable not defined 4

Top