View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
STEVE BELL STEVE BELL is offline
external usenet poster
 
Posts: 692
Default 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.