acMsgBoxStyle

Member	Value	Description
vbOKOnly	0	Displays OK button only.
vbOKCancel	1	Displays OK and Cancel buttons.
vbAbortRetryIgnore	2	Displays Abort, Retry, and Ignore buttons.
vbYesNoCancel	3	Displays Yes, No, and Cancel buttons.
vbYesNo	4	Displays Yes and No buttons.
vbRetryCancel	5	Displays Retry and Cancel buttons.
vbCritical	16	Displays Critical Message icon.
vbQuestion	32	Displays Warning Query icon.
vbExclamation	48	Displays Warning Message icon.
vbInformation	64	Displays Information Message icon.
vbDefaultButton1	0	First button is default.
vbDefaultButton2	256	Second button is default.
vbDefaultButton3	512	Third button is default.
vbApplicationModal	0	Application is modal. The user must respond to the message box before continuing work in the current application.
bnSystemModal	4096	System is modal. All applications are suspended until the user responds to the message box.
vbMsgBoxSetForeground	65536	Specifies the message box window as the foreground window.
vbMsgBoxRight	524288	Text is right-aligned.
vbMsgBoxRtlReading	1048576	Specifies text should appear as right-to-left reading on Hebrew and Arabic systems.

More than one of the options can be chosen, add numbers together to combine them.

The first group of values (0–5) describes the number and type of buttons displayed in the dialog box.
The second group (16, 32, 48, 64) describes the icon style.
The third group (0, 256, 512) determines which button is the default.
The fourth group (0, 4096) determines the modality of the message box,
The fifth group (65536 +) specifies whether or not the message box window is the foreground window, along with the alignment and direction of the text.

When adding numbers to create a final value for the Buttons argument, use only one number from each group.

Example

vbOKCancel + vbExclamation

“An honest tale speeds best being plainly told” ~ William Shakespeare (Richard III)

Related:

InputBox - Prompt for user input.
MsgBox - Display a message in a dialogue box.