Macro using question to proceed or stop

  • Thread starter Thread starter mohavv
  • Start date Start date
M

mohavv

Hi,

I want to add a question to my macro if it is ok to run it or not (Are
you sure? Y/N).
So if you click yes it will proceed and if you click no it will stop.

I can't find out how to do this. Found Userform but I don't know how
to use it in a macro.

Any help pm this is welcome.

Cheers
 
Try this
Sub yesOrNo()
If MsgBox("Run macro? Yes or No", vbYesNoCancel + vbQuestion) <> vbYes Then
MsgBox "NO Dont Run Macro"
Else
MsgBox "Run Macro"
End If
End Sub
 
Don't need a user form, a simple msgbox will do.

Sub foo()

Style = vbYesNo
msg = "are you sure you want to run macro?"
Response = MsgBox(msg, Style)
If Response = vbYes Then
If Response = vbNo Then Exit Sub

your code goes here

End If
End Sub


Gord Dibben MS Excel MVP
 
Try this
Sub yesOrNo()
If MsgBox("Run macro? Yes or No", vbYesNoCancel + vbQuestion) <> vbYes Then
MsgBox "NO Dont Run Macro"
Else
MsgBox "Run Macro"
End If
End Sub









- Show quoted text -
Click to expand...

Thanks!
Works just fine.

If life was always this simple....

Cheers,

Harold
 
Back
Top