Add a warning popup to a Macro Button
 

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?

Add a warning popup to a Macro Button
 

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?

Add a warning popup to a Macro Button
 

else exit sub
End If
??
--
paul
remove nospam for email addy!



"Bob Phillips" wrote:

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?

Add a warning popup to a Macro Button
 

Hi

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

Kind regards

Teresa

"Bob Phillips" wrote:

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?

Add a warning popup to a Macro Button
 

Hi

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

Kind regards

Teresa

"paul" wrote:

else exit sub
End If
??
--
paul
remove nospam for email addy!



"Bob Phillips" wrote:

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?