Print textbox-content possible?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maurice - 26 Jan 2007 12:55 GMT

Hi,

Just trying to find out if this is possible.
I have a textbox placed on my worksheet and it's properties set to scrollbar
vertical. Now I can typ all te text I want even if it doesn't fit because I
can scroll up and down. Now here's my question: When I want to print this
textbox it only prints the visible part of the textbox. Is it possible to
print out the total content of the textbox?

Or should I use a userform and than add the content by placing it in a
dynamic cell.

Let me know if it is possible. Thanks in advance

Maurice

Reply to this Message

spences10 - 26 Jan 2007 13:02 GMT

Hi Maurice,

Unfortunately for you I do not have a solution - but I am wondering
if anyone knows if there is a way to copy and paste the contents from
the text box to another object or application.

Thank you in advance for any help.

> Hi,
>
[quoted text clipped - 11 lines]
>
> Maurice

Reply to this Message

Tom Ogilvy - 26 Jan 2007 16:11 GMT

Dim s as String
s = worksheets("Sheet1").Textbox1.Text

worksheets("Sheet2").Textbox3.Text = s

Signature

Regards,
Tom Ogilvy

> Hi Maurice,
>
[quoted text clipped - 19 lines]
> >
> > Maurice

Reply to this Message

Tom Ogilvy - 26 Jan 2007 16:10 GMT

You could have your code copy the text to a new worksheet, print the
worksheet, delete the worksheet.

You could have your code seize the textbox so shows all the text, print the
textbox, restore the original size of the textbox.

Signature

Regards,
Tom Ogilvy

> Hi,
>
[quoted text clipped - 11 lines]
>
> Maurice

Reply to this Message