Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How To Print the contents of a TextBox
All,
Thank You in advance for any ideas. I have a Textbox on a UserForm that gets popullated with error messages. I would like my users to be able to Print the text inside the textbox. Ideally the PrintDialog box would open with there default printer selected. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How To Print the contents of a TextBox
I'm sure there is an easier way, but I'm not advanced enough to know it.
I would transfer the text box value to a new sheet and than print that sheet. The code could insert a new sheet, transfer the text, print the sheet, and than delete the sheet. Try this with a copy of your workbook. You should be able to record most of the code. Post back if you need help with the code, but be aware that except for the text transfer - I will just record and modify the code. You can also use the same code that fills the text box to also add entries to a blank sheet. -- steveB Remove "AYN" from email to respond "DMS" wrote in message ... All, Thank You in advance for any ideas. I have a Textbox on a UserForm that gets popullated with error messages. I would like my users to be able to Print the text inside the textbox. Ideally the PrintDialog box would open with there default printer selected. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Contents of a TextBox to HTML | Excel Programming | |||
How do I print the contents of a textbox that is on a Userform | Excel Programming | |||
Putting Cell contents into a TextBox? | Excel Programming | |||
Copy textbox contents | Excel Programming | |||
clear textbox contents | Excel Programming |