How To Print the contents of a TextBox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top