+ Reply to Thread
Results 1 to 4 of 4

Print preview for a User Form OR Select a printer from list of avaiable

  1. #1
    Registered User
    Join Date
    03-12-2008
    Location
    Melbourne
    Posts
    32

    Question Print preview for a User Form OR Select a printer from list of avaiable

    Hi again everyone.

    I'm approaching completion on this project but I just need a little bit more help, this time with printing User Forms. As per attached workbook, if you are on the 'MASTER' sheet and you press the [Print] button, select one of the entry and click [Continue] this loads the UserForm 'Print_UI'. Here, I would like to have the three buttons to work, [Cancle] is already done and technically, [Print] works; I've made sure the Form prints nicely on A4, but it prints to what ever is set as the default.

    I found some code somewhere that gives you a list of printer that you can access but choosing one does not seem to apply to the [Print] button. So my question is two fold;
    1) Is there a Form version of
    Please Login or Register  to view this content.
    ? Because if there is, a printer can be selected from a print preview (I think) OR,
    2) Is there a way to make
    Please Login or Register  to view this content.
    work? Because that would do nicely too

    I've had a good look around and the other options take a screenshot of the form and paste it into a sheet to print, but I don't like how it looks when it's done that way.

    Thanks in advance,
    Hobbit
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    362

    Re: Print preview for a User Form OR Select a printer from list of avaiable

    this link may have some useful clues.


  3. #3
    Registered User
    Join Date
    03-12-2008
    Location
    Melbourne
    Posts
    32

    Re: Print preview for a User Form OR Select a printer from list of avaiable

    I tried that torachan and it does work, but it does not quite meet my requirements. I've found scrips in the past that will take a screen shot, but I need it to just print the form. It looks fine when it does that, but I'd like to have control over where it prints to.

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    2,950

    Re: Print preview for a User Form OR Select a printer from list of avaiable

    Personally, I would have a sheet set up that looks how you want it, populate it with the form data and print that sheet.
    Rory
    Days when we raged, we flew off the page
    Such damage was done

+ 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