+ Reply to Thread
Results 1 to 4 of 4

Print button to print userform

  1. #1
    Forum Contributor
    Join Date
    07-26-2007
    MS-Off Ver
    2007
    Posts
    102

    Print button to print userform

    I added a print button to my userform

    Please Login or Register  to view this content.
    This prints out the userform as I would like, however it autoprints to the default printer and doesn't allow any printing options so I can't select to "print to one page". So as of now it is only printing out half my form and cutting off the rest.

    Any suggestions?

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Print button to print userform

    Try adding this line of code, before printing the form, to show the Printer dialog.
    Make your printer changes then close the dialog.

    Please Login or Register  to view this content.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Forum Contributor
    Join Date
    07-26-2007
    MS-Off Ver
    2007
    Posts
    102

    Re: Print button to print userform

    That code will bring up the print options screen, however, none of the changes made in that screen effect the actual output of the print. It is still printing out cutoff

  4. #4
    Valued Forum Contributor
    Join Date
    05-14-2009
    Location
    gold coast
    MS-Off Ver
    Excel 2007
    Posts
    823

    Re: Print button to print userform

    if the trouble you are having is that the userform falls outside the printers range,

    You could resizee the form
    untested.
    Please Login or Register  to view this content.
    hope this helps

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1