Add a warning popup to a Macro Button

[Guest]

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?

 

[Bob Phillips]

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)

 

[Guest]

else exit sub
End If
??

 

[Guest]

Hi

Thanks for this - however I'm a complete novice - what am I supposed to do
with it?

Kind regards

Teresa

 

[Guest]

Hi

Thanks for this - however I'm a complete novice - what am I supposed to do
with it?

Kind regards

Teresa