I did a search and haven't found a good answer. All I want to do i
create a subroutine to print the contents of a given textbox (I hav
nine to print).

I've designed a spreadsheet to look like a form. There are nin
textboxes for user memo input. Only three lines of text are availabl
for viewing but I have the scrollbar property set and that works fine
The person who receives the sheet wants the ability to print out th
form, including ALL of the text.

Doing a FOR EACH loop to set the AutoSize to True causes the verticall
arranged textboxes to overlap each other if there is a lot of text i
them

--
Air_Cooled_Nu

-----------------------------------------------------------------------
Air_Cooled_Nut's Profile: http://www.excelforum.com/member.php...fo&userid=1573
View this thread: http://www.excelforum.com/showthread.php?threadid=27300