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

"mohavv" wrote:

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