Who Can Develop a new vbPrint?

  • Thread starter Thread starter Curious
  • Start date Start date
C

Curious

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert a File, not a Comment, to a Cell 3
Who Can Expand Chip Pearson's procedure ExportToTextFile? 8
dataset to RTF format in browser and then javascript print 3
Get word from a string 5
Each Stakeholder of A File Must Select His Name (Only) 1
End a procedure form a UserForm 3
End a procedure from a UserForm 1
Cancel Print? 2

Back
Top