+ Reply to Thread
Results 1 to 4 of 4

Printing a userform - Not working

  1. #1
    Forum Contributor
    Join Date
    06-06-2012
    Location
    Toronto, ON
    MS-Off Ver
    Office 365
    Posts
    138

    Printing a userform - Not working

    Hello All,

    Im trying to do something here I cant quite figure out. Im trying to add a print button to a userform. But three things that have to happen when the button is clicked:
    1. Excel has to tell the print dialogue box to ensure the page will only fit on one page by one page
    2. The print dialogue box has to pop up so the user can ensure the settings of the print
    3. Right now when the print happens scroll bars are printing from the userform. I need those to disappear

    This code in its current state is messing with me, it appears I set it to one page by one page but yet when the print happens its only printing the last part of my userform. And right now it also does trigger the dialogue box so that part is solved. I just cant figure out why its not resizing to one page by one page. Any thoughts?

    Code:
    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: Printing a userform - Not working

    There's not an lot you can do to control how a userform is posted, they don't even have a PageSetup property/method.

    Usually it's better to transfer the data to a (temporary?) sheet and then print that.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    06-06-2012
    Location
    Toronto, ON
    MS-Off Ver
    Office 365
    Posts
    138

    Re: Printing a userform - Not working

    hmm, well I could play with that process. Thanks for the idea! Let me ask this:

    I can get Excel to do what I need it to do with that code...I actually got the whole thing to print on one page by two paegs. But as soon as I adjust to 1 page by 1 page thats when it cuts the form....Is there any way to fix that? If not I will just play with the whole transferring the data to a sheet and setting the print area.


    Quote Originally Posted by Norie View Post
    There's not an lot you can do to control how a userform is posted, they don't even have a PageSetup property/method.

    Usually it's better to transfer the data to a (temporary?) sheet and then print that.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: Printing a userform - Not working

    Sounds like you are managing to set things up as you want with the print dialog but then those settings are just being ignored.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Printing a UserForm
    By dgingrey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2013, 12:04 PM
  2. userform for printing
    By blackman87 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-20-2010, 07:53 AM
  3. UserForm Printing
    By PATRON58 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-02-2007, 02:30 AM
  4. UserForm Printing
    By jclarke17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2006, 08:25 PM
  5. [SOLVED] userform printing
    By Access in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2005, 12:05 AM

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