Print scrollable user form.

C

cparsons

I have a user form that uses scroll bars. I added a button at th
bottom of the form to print what is on the user form. The cod
executed is userform.Printform. The only part of the form that print
is the part of the form that is in the user window. How can I get th
whole form to print, including what is out of the user window?


Thanks,
Crai
 
C

cparsons

Ok - It seems that printform will only print what the users sees. Doing
some research I have found that I need to enclose everything in my form
into a PictureBox and then print the PictureBox.

Can anybody help me with adding the PictureBox control to my toolbox?

Thanks,
Craig
 
T

TomHinkle

When it prints, in the macro, set the .height property of the form
sufficiently to have all the information displayed... then after the
..printform, reset the .height property
 
Top