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