Add a warning popup to a Macro Button

T

Teresa

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?
 
B

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)
 
T

Teresa

Hi

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

Kind regards

Teresa
 
T

Teresa

Hi

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

Kind regards

Teresa
 
Top