How To Make A VBA Msgbox Yes No

You can use a VBA Msgbox Yes No to get guidance from the user an the control your program’s flow

In the following example I am asking the user to confirm whether or not they want to continue.

I am storing the answer in the integer variable intAnswer, and then my algorithm processes their answer which
will ultimately control the flow of the program.

Sub VBAMsgboxYesNo()
    
    Dim intAnswer As Integer
    
    intAnswer = MsgBox("Would you like to continue", vbYesNo, "Continue?")
    
    Select Case intAnswer
        Case vbYes
            MsgBox "Continue", vbInformation, "Answer"
            
        Case vbNo
            MsgBox "Stop", vbInformation, "Answer"
    
    End Select

End Sub

Please let me know if you have any questions.




By the way, if you got or are getting value from the VBA information, please give me a tip, thanks!


These posts may help answer your question too...

Here Is A Customized Msgbox VBA Example

Here is an example of a customized VBA Msgbox. We giving some richtext and customizable flair to the rather ordinary message box. The following code provided with the code after the screenshot, is going to provide you with the ability to really make the ordinary message box shine! Sub MsgboxVBAExamples() Dialog.Box “VBAHowTo.com is your source […]

How To Use A Variable In A VBA Message Box.

In this post I’m going to show you how to use a variable in a vba message box. This is used commonly to notify the user that an entered item in a combo box is not in the list, also per this post it’s to display the error number or the error description to the […]

VBA Msgbox New Line Example

Here is an example of a vba msgbox with new line   Sub VBAMsgboxNewLine() Dim strText As String ‘Here I am using the enum version of the character feed. ‘strText = “Please try your operation ” & vbCrLf & ” again” ‘Chr(10) and Chr(13) do pretty much the same thing in VBA ‘Chr(10) is a […]

How To Use The VBA Input Box Cancel Button To Exit Sub

This post will demonstrate how you can use the VBA input box cancel button to exit the sub procedure. When you click the “Cancel” button on the input box, you return a null (blank) value, and knowing this information, you can exit the sub procedure. Here is an example:   Sub VBAInputBoxCancel() Dim strResponse As […]

Previous Post

How To Use A Variable In A VBA Message Box.

Next Post

VBA Msgbox New Line Example