+ Reply to Thread
Results 1 to 5 of 5

Print User Form

  1. 03-29-2014, 06:45 AM #1
    kachuen2006
    kachuen2006 is offline
    Registered User
    Join Date
    08-07-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    45

    Print User Form

    I would like to print out the userform but i know its far more easier to print the form in an worksheet format so that i have copied the data into another worksheet. However, the form can't be printed after button pressed. Please give me a helping handtest2.xlsm
    Reply With QuoteRegister To Reply
  2. 03-29-2014, 01:02 PM #2
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Print User Form

    Hi kachuen2006

    I've added Code to your UserForm Print Button to print the Form. Notice also, items have been added to the mGlobals Module.

    Why is your File so large?
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
  3. 03-30-2014, 12:46 PM #3
    kachuen2006
    kachuen2006 is offline
    Registered User
    Join Date
    08-07-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: Print User Form

    Hi jaslake, thanks for your reply, i got some error on running your attached. can you explain what you have been add as i can see it will open a new spreadsheet and stop after that. And i have modified my code so that it works for me now

    Please Login or Register  to view this content.
    Last edited by kachuen2006; 03-30-2014 at 12:58 PM.
    Reply With QuoteRegister To Reply
  4. 03-30-2014, 01:01 PM #4
    kachuen2006
    kachuen2006 is offline
    Registered User
    Join Date
    08-07-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: Print User Form

    THANKS Fotis
    Reply With QuoteRegister To Reply
  5. 03-30-2014, 04:35 PM #5
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Print User Form

    Hi kachuen2006

    I'm not sure what you're asking but here's what I believe you asked for...
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Simplified Print user form
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2012, 02:24 AM
  2. Print preview from user form opened from a user form
    By Brunstgnegg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2011, 05:12 AM
  3. [SOLVED] User form - print Landscape
    By Priya Menan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2006, 11:45 PM
  4. Print scrollable user form.
    By cparsons in forum Excel General
    Replies: 2
    Last Post: 08-04-2005, 12:05 PM
  5. User Form Print
    By Woo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2005, 11:51 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1