Thread
:
Are you sure popup box
View Single Post
#
2
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
Are you sure popup box
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
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson