How do I print the contents of a textbox that is on a Userform
 

This problem has been driving me up a wall. It seems very easy but I can't
find the answer anywhere.

I have a Userform with a text box on it. I use this textbox to list errors
that my macro finds. I would like my users to be able to print the contents
of the textbox. Any ideas.

I have tried the following.
Printer.Print Userform1.textbox1.text

When I run this code I get an error that says "Object Required"

Any help would be appreciated.

DMS

How do I print the contents of a textbox that is on a Userform
 

I'm not sure if this will work but give it a try.
Range("A1").Select
ActiveCell = Userform1.textbox1
ActiveSheet.PageSetup.PrintArea = "$A$1"
ActiveCell.Columns
("A:A").EntireColumn.EntireColumn.AutoFit
ActiveWindow.SelectedSheets.PrintOut Copies:=1,
Collate:=True

Let me know how this turns out. Replace A1 and "$A$1"
with a blank cell somewhere in your worksheet where you
could print the output.
Mike J
-----Original Message-----
This problem has been driving me up a wall. It seems
very easy but I can't
find the answer anywhere.

I have a Userform with a text box on it. I use this
textbox to list errors
that my macro finds. I would like my users to be able
to print the contents
of the textbox. Any ideas.

I have tried the following.
Printer.Print Userform1.textbox1.text

When I run this code I get an error that says "Object
Required"

Any help would be appreciated.

DMS
.