View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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