View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Print a Userform To Fit On One Page

Maybe resize the userform before printing to shrink it to within the page
breaks?

"RyanH" wrote:

I would like to print a userform with a commandbutton, but the entire
userform does not fit on the page. Is there a way to click the control
button that is located on the userform and print the form to fit on one page?

This is what I have:

Private Sub btnPrint_Click()

frmItemSummary.PrintForm
MsgBox "Item # " & Cells(ActiveCell.Row, "A") & " has been sent to the
Printer.", vbInformation

End Sub
--
Cheers,
Ryan