| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print a Userform To Fit On One Page
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting the print area in page set up to print 1 page wide by 2 pages tall | Excel Discussion (Misc queries) | |||
| PRINT PAGE BREAK VIEW AS WATERMARK FIOR EACH PAGE | Setting up and Configuration of Excel | |||
| Print all pages in a Multi page userform | Excel Programming | |||
| How to print a page of a multipage userform | Excel Programming | |||
| Hide a page in a multi page userform | Excel Programming | |||
Threaded Mode
