The MsgBox buttons argument's settings
Default button settings
vbDefaultButton1 0 The first button is default
vbDefaultButton2 256 The second button is default
vbDefaultButton3 512 The third button is default
vbDefaultButton4 768 The fourth button is default
Message box modality
vbApplicationModal 0 The user must respond to the message before continuing to work in the current application.
vbSystemModal 4096 On Win16 systems, this constant is used to prevent the user from interacting with any other window until he or she dismisses the message box. On Win32 systems, this constant works like the vbApplicationModal constant (see above) with the following exception: The message box always remains on top of any other programs you may have running.
Other MsgBox display settings
vbMsgBoxHelpButton 16384 Adds the Help button to the message box
vbMsgBoxSetForeground 65536 Specifies the message box window as the foreground window
vbMsgBoxRight 524288 Text is right aligned
vbMsgBoxRtlReading 1048576 Text appears as right-to-left reading on Hebrew and Arabic systems
Sub buttonMsg()
MsgBox "How are you?", vbOKOnly + vbApplicationModal, "Application Modal"
End Sub
Related examples in the same category
| 1. | Using the MsgBox Function: MsgBox (prompt [, buttons] [, title], [, helpfile, context]) | | |
| 2. | A single statement splits over four lines. | | |
| 3. | Buttons and Icons in the MsgBox Function | | |
| 4. | MsgBox "Welcome to VBA", vbYesNoCancel, "VBA Message Box" | | |
| 5. | Add the Information icon | | |
| 6. | Use Chr() function to format MsgBox | | |
| 7. | Use & to link messages | | |
| 8. | Pass single parameter to MsgBox | | |
| 9. | Keep the message box visible while the user works with other open applications | | |
| 10. | Set default button for MsgBox | | |
| 11. | Using the MsgBox Function with Arguments | | |
| 12. | MsgBox with three parameters | | |
| 13. | Call MsgBox function by using its parameter name | | |
| 14. | MsgBox with parameter Name: title:=myTitle, prompt:=question, buttons:=myButtons, helpfile:= "HelpX.hlp",context:=55 | | |
| 15. | Returning Values from the MsgBox Function | | |
| 16. | Save the return value from MsgBox to a variable | | |
| 17. | Each of the available buttons will produce an integer result. | | |
| 18. | Check MsgBox result | | |
| 19. | determines which button was pressed. | | |
| 20. | Using the Select Case Statement to check the MsgBox button clicked | | |
| 21. | MsgBox's third parameter is the message box's title. Its fourth and fifth parameters are the Help file and context ID | | |
| 22. | The message box displays Yes, No, and Cancel buttons | | |
| 23. | After you have placed the return value into a variable, you can easily introduce logic into your program to respond to the user's selection | | |
| 24. | Ok To Overwrite | | |
| 25. | Getting a response from a message box with Select Case | | |
| 26. | use the MsgBox function result without using a variable | | |
| 27. | Specifying a Title for a Message Box | | |
| 28. | Adding a Help Button to a Message Box: use the vbMsgBoxHelpButton constant | | |
| 29. | Specifying a Help File for a Message Box | | |