Hi.
In an excel 2000 workbook I've a Userform with a large textbox whose contents I would like to allow users to print.
If I use method Printform, the entire form will be printed (all Bits).
So my first question is:
is there a way to print (Directly) only the contents of a textbox (without linking it to some cell in a worksheet which causes formatting problems)?
My second question:
if a textbox has scrollbars, printform prints only the visible part of text.
is there a way to print the entire contents of a textbox though scrollbars value doesn't allow to see all the text?
Thank you in advance.
Regards
Nick
In an excel 2000 workbook I've a Userform with a large textbox whose contents I would like to allow users to print.
If I use method Printform, the entire form will be printed (all Bits).
So my first question is:
is there a way to print (Directly) only the contents of a textbox (without linking it to some cell in a worksheet which causes formatting problems)?
My second question:
if a textbox has scrollbars, printform prints only the visible part of text.
is there a way to print the entire contents of a textbox though scrollbars value doesn't allow to see all the text?
Thank you in advance.
Regards
Nick