ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   message box program flow (https://www.excelbanter.com/excel-programming/274978-re-message-box-program-flow.html)

losmac

message box program flow
 
Sub ZZZZ()
Dim retVal As Long

retVal = MsgBox("???", vbYesNoCancel + vbQuestion + vbDefaultButton1)

Select Case retVal
Case vbYes
MsgBox "YES"
Case vbNo
MsgBox "NO"
Case vbCancel
MsgBox "CANCEL"
End Select
End Sub


Uzytkownik "Steven Wathen" napisal w
wiadomosci ...

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!





All times are GMT +1. The time now is 01:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com