Hi

I have a macro assigned to a button on my spreadsheet, but I would like to
have a confirmation box pop up asking the user if they are sure they want to
proceed. Obviously i need the pop up to proceed with running the macro if
they choose yes and to stop the macro if they choose no. Thanks for any
advice.

This might work
If MsgBox("Click yes to proceed or no to cancel", vbQuestion + vbYesNo) <
vbYes Then
MsgBox ("you clicked no")
'do nothing
Else
MsgBox ("you clicked yes")
'do something
End If

"Leigh Douglass" wrote:

Hi

I have a macro assigned to a button on my spreadsheet, but I would like to
have a confirmation box pop up asking the user if they are sure they want to
proceed. Obviously i need the pop up to proceed with running the macro if
they choose yes and to stop the macro if they choose no. Thanks for any
advice.