Check MSDN's info on VBA.MsgBox. You have some options for how it appears using the VBMsgBoxStyle constants:
Button choices include:
vbAbortRetryIgnore, vbOKCancel, vbOKOnly, vbRetryCancel, vbYesNo, vbYesNoCancel
Additional graphics include:
vbCritical, vbExclamation, vbInformation, vbQuestion
See MSDN for complete details. If you don't see it in there,
then you'll have create a form and customize it to suit your needs.
scarfhead