+ Reply to Thread
Results 1 to 6 of 6

To print report from a userform

  1. #1
    Registered User
    Join Date
    03-05-2016
    Location
    India
    MS-Off Ver
    6
    Posts
    16

    Question To print report from a userform

    Hi,

    How to print a report (source: two worksheets based report) from a user form command button.


    Thanks..!

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: To print report from a userform

    Start your macro recorder

    Record yourself printing your two sheets.

    Copy the Macro code and paste it into the macro for your command button.

    If you are in the user form designer, clicking on the command button will open the macro window for you.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    03-05-2016
    Location
    India
    MS-Off Ver
    6
    Posts
    16

    Re: To print report from a userform

    Hi,

    Did you meant to the Printer from recorder...? I am looking to print the reports to a printer.

    Thanks...!

  4. #4
    Forum Contributor
    Join Date
    09-03-2015
    Location
    IE
    MS-Off Ver
    2003 - 2016
    Posts
    258

    Re: To print report from a userform


  5. #5
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: To print report from a userform

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    03-05-2016
    Location
    India
    MS-Off Ver
    6
    Posts
    16

    Re: To print report from a userform

    Thank you so much..!

+ 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. [SOLVED] UserForm to print report for month/year
    By antcha in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2015, 01:35 AM
  2. How to Print only contents of TextBox from UserForm not whole Userform
    By khurramali2010 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2014, 08:39 AM
  3. Macro to Set Print Area and Print Report
    By jaredmccullough in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-14-2014, 04:03 AM
  4. How to put into userform that can select number of page to print using userform?
    By reimar_rem in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-16-2013, 11:33 PM
  5. [SOLVED] REfocus on userform after print command within the userform
    By chrisjames25 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2013, 02:29 PM
  6. [SOLVED] Click Print on Userform and Print a file
    By stojko89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2011, 07:57 AM
  7. Print Button to print UserForm for multi-sheet
    By smartcard in forum Excel General
    Replies: 12
    Last Post: 04-29-2010, 07:47 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