Microsoft Office Tutorials and References
In Depth Information
Table 4-9. Button Options for Message Boxes
Intrinsic Constant
Value
Description
Default Button
vbDefaultButton1
0
Sets the first button as the default button.
vbDefaultButton2
256
Sets the second button as the default button.
vbDefaultButton3
512
Sets the third button as the default button.
vbDefaultButton4
768
Sets the fourth button (such as a Help button)
as the default button.
Modality
vbApplicationModal
0€
Marks the message box as application modal.
Stops all processing of the current application
until the message box is dismissed. Does not
interfere with any other applications.
vbSystemModal
4096
Marks the message box as system modal; it will
always appear as the topmost window regardless
of which application the user switches to.
vbMsgBoxHelpButton
16384
Adds a Help button to the message box.
vbMsgBoxSetForeground
65536
Causes the message box to be displayed in the
foreground.
vbMsgBoxRight
524288
Causes the text in the message box to be
rightaligned.
vbMsgBoxRtlReading
1048576
Causes the text to be displayed right-to-left on
Hebrew and Arabic systems.
Table 4-10. Values Returned by a Message Box
Intrinsic Constant
Value
vbOk
1
vbCancel
2
vbAbort
3
vbRetry
4
vbIgnore
5
vbYes
6
vbNo
7
If a Cancel button is displayed in the message box, pressing Esc has the same effect as clicking
it. You should select exactly one option from each group; if more than one is selected, Excel
will use the option with the highest value.
You can display a simple message box just by providing the title argument.
Search JabSto ::




Custom Search