procedure to populate message box with yes or no if I run the macro

[Mussa]

Hi guys,
I search for procedure to put before my macro .when I click button to run the macro then should show message " are you sure to running?" if I click ok then will run the macro , if I click no then shouldn't run the macro also if I close the message without I do anything then shouldn't do anything .
thanks

 

[Michael M]

Put this at the start of your code

ans = MsgBox("are you sure you want to continue ?", vbYesNo)
If ans = vbNo Then Exit Sub

 

[Mussa]

thank you so much

 

[Michael M]

Glad to help