Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print textbox-content possible?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print textbox-content possible?
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. Maurice wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print textbox-content possible?
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. -- Regards, Tom Ogilvy "Maurice" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print textbox-content possible?
Dim s as String
s = worksheets("Sheet1").Textbox1.Text worksheets("Sheet2").Textbox3.Text = s -- Regards, Tom Ogilvy "spences10" wrote: 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. Maurice wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
content on textbox within userform | Excel Programming | |||
UserForm1 Not Displaying Textbox Content | Excel Programming | |||
Check the content of a textbox? | Excel Programming | |||
Textbox Content Type | Excel Programming | |||
Copy a cell content into a TextBox | Excel Programming |