I used to use msgbox to show a long message. Some times with a
vbYesNoCancel, or with vbYesOnly. I am wondering if I can get a
vbPrint (but I do not know how). I want to print the message or creat
a new worksheet with the message.

Can you help?

H.Z.

I'm a bit confused. vbYesNoCancel and vbYesOnly are integer constants
that tell the MsgBox() method what buttons to display.

You can't add functionality to MsgBox by generating new constants.

If you want different options, one way is to display a userform which
you create, where you can assign your long message to a label, and which
includes command buttons that you can code to print the message, or to
create a new worksheet with the message.

In article
<b7d4b2f1-7c29-435d-a2a1-(E-Mail Removed)>,
Curious <(E-Mail Removed)> wrote:

> I used to use msgbox to show a long message. Some times with a
> vbYesNoCancel, or with vbYesOnly. I am wondering if I can get a
> vbPrint (but I do not know how). I want to print the message or creat
> a new worksheet with the message.