RE: MsgBox Replacement w/ an UserForm

From: sebastienm (sebastienm_at_discussions.microsoft.com)
Date: 10/09/04 

Date: Sat, 9 Oct 2004 09:07:02 -0700

Hi,
I don't have code, but just a few details about MsgBox (see online help):
You have other buttons available in msgbox:
-vbOKOnly 0 Display OK button only.
-vbOKCancel 1 Display OK and Cancel buttons.
-vbAbortRetryIgnore 2 Display Abort, Retry, and Ignore buttons.
-vbYesNoCancel 3 Display Yes, No, and Cancel buttons.
-vbYesNo 4 Display Yes and No buttons.
-vbRetryCancel
So if want to display Abort,Retry,Ignore buttons with a Warning icon:
 MsgBox "did Not Work!", vbAbortRetryIgnore + vbCritical, "TEST"
as you can see , you just have to add the vbMsgBoxStyle in the Buttons
parameter as in : vbAbortRetryIgnore + vbCritical

Would that be enough flexibility in your case?
But maybe you already know about that and it doesn't fit your needs.

Regards,
Sebastien
"Chuckles123" wrote:

>
> Bob,
> Thanks.
> Formatting is easier in a Form. Also, the 'Yes-No' buttons are not
> applicable to the options that I am giving the user.
> I would appreciate if you or someone could give me a few lines of
> code.
> Chuckles123
>
>
> --
> Chuckles123
> ------------------------------------------------------------------------
> Chuckles123's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14948
> View this thread: http://www.excelforum.com/showthread.php?threadid=267872
>
>