I was answering the original post--not responding to your message.

Your message wasn't there when I retrieved the headers, so I answered the
question.

Orion Cochrane wrote:

That's what I said. Did you put the code at the beginning of your macro?
--
Please rate posts so we know when we have answered your questions. Thanks.

"Dave Peterson" wrote:

Or you could just ask the question at the top of your existing routine:

Option Explicit
Sub YourSubNameHere()

'your declaration statements
dim Resp as long 'added

resp = msgbox(Prompt:="Are you sure?", buttons:=vbyesno)

if resp = vbno then
exit sub
end if

'your real code here
End Sub



scott wrote:

I have created a macro in excel that clears all input data and assigned it to
a button. I need to put in a pop-up form that asks "Are you Sure" (yes/no).
Yes continues the macro; No puts you back into the spreadsheet.

--

Dave Peterson


--

Dave Peterson