Hi,

I'm trying to write a macro that uses the MsgBox function to select which one of two macros should be run.

The actual macros themselves run fine, but trying to tie them together is proving difficult. I looked around online and couldn't find any clues, so this particular solution may not even be possible.

I have this macro which functions as I'd expect it to:

Sub MACRO()
If MsgBox("Run Macro A?", vbYesNo) = vbYes Then Macro A
End Sub

I want to add something to the effect of:

= vbNo Then Macro B

If I substitute the vbYes line for this vbNo line it runs as expected but can't get it to do both without prompting two message boxes.

It's so simple that I'm hoping there is an easy answer and I don't have to go about a completely different solution.

Any help is greatly appreciated.