View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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
.