Dim ans as long

ans = MsgBox("Are you sure?, vbYesNo)
if ans = vbYes Then
... your code
End If

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Teresa" wrote in message
...
I have created a button and assigned a recorded macro to it that clears
the
contents of the entire worksheet - however I've had a second thought & now
want a warning to popup when the button is clicked that the person has to
click through before the macro will run - kind of like the old "Are you
sure?" message. How can I do this with very limited knowledge?