Thread
:
message box program flow
View Single Post
#
1
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
message box program flow
Steven,
Try something like
Dim Res As VbMsgBoxResult
Res = MsgBox("Message", vbYesNoCancel)
If Res = vbYes Then
' user clicked yes
ElseIf Res = vbNo Then
' user clicked no
Else
' user clicked cancel
End If
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Steven Wathen" wrote in message
...
I`ve got a message box with the vbyesnocancel buttons on. How do
i make
my program go in different directions depending on the choice
made in
the message box. what value or constant changes when each
different
button is pressed??
*** Sent via Developersdex
http://www.developersdex.com
***
Don't just participate in USENET...get rewarded for it!
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson