How do you get a simple little popup box or message to pop
up when you click a command button before the code runs?
I want the popup box to say something like "Are you sure"
and then give the user an option to click Yes or No, or
Cancel. If the user click no or cancel the code does not
run, if the user clicks Yes, the popup box goes away and
then the code run.

How do I do this?


Thanx

Todd Huttenstine

Todd,

Use the MsgBox function. For example

If MsgBox("Are you sure?", vbYesNo) = vbNo Then
Exit Sub
End If

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Todd Huttenstine" wrote in message
...
How do you get a simple little popup box or message to pop
up when you click a command button before the code runs?
I want the popup box to say something like "Are you sure"
and then give the user an option to click Yes or No, or
Cancel. If the user click no or cancel the code does not
run, if the user clicks Yes, the popup box goes away and
then the code run.

How do I do this?


Thanx

Todd Huttenstine

Thanx, comes in very handy.
-----Original Message-----
Todd,

Use the MsgBox function. For example

If MsgBox("Are you sure?", vbYesNo) = vbNo Then
Exit Sub
End If

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Todd Huttenstine"
wrote in message
...
How do you get a simple little popup box or message to
pop
up when you click a command button before the code runs?
I want the popup box to say something like "Are you
sure"
and then give the user an option to click Yes or No, or
Cancel. If the user click no or cancel the code does
not
run, if the user clicks Yes, the popup box goes away and
then the code run.

How do I do this?


Thanx

Todd Huttenstine


.