Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Who Can Develop a new vbPrint?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Who Can Develop a new vbPrint?
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 , Curious 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help to develop a % formula | Excel Discussion (Misc queries) | |||
Trying to develop equation | Excel Discussion (Misc queries) | |||
why shouldnt develop in access | Excel Programming | |||
Develop 230 Graphs from Data | Excel Programming |