+ Reply to Thread
Results 1 to 6 of 6

Print or PDF a User Form

  1. #1
    Forum Contributor
    Join Date
    02-16-2016
    Location
    england
    MS-Off Ver
    11
    Posts
    115

    Print or PDF a User Form

    Hi all,

    I have a user form and i need to have the ability to "PDF" the form or "Print" the form using command buttons, i have searched the threads on the forum but havent been able to locate one.

    Could anyone offer any help?

    Thanks D

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Print or PDF a User Form

    Good morning deanblew

    UserForms are designed to show information on screen - not print out. There's no real way to do this.

    If you want to access the data that is shown on these forms, then that will be stored somewhere within the file.

    If you want to design, say, a user manual and need to show sample userforms within that, then you will need to use either the Snipping Tool or PrntScrn and cut and paste the form.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Print or PDF a User Form

    this will print userform
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    02-16-2016
    Location
    england
    MS-Off Ver
    11
    Posts
    115

    Re: Print or PDF a User Form

    Great thanks for your help

  5. #5
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Print or PDF a User Form

    Glad to help, please marked as solved if that sorts your question

  6. #6
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Print or PDF a User Form

    Why not?
    Please Login or Register  to view this content.
    Click the * Add Reputation below to say thanks.

+ 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] How can I Print my user form?
    By bralew in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-11-2016, 10:42 AM
  2. Print a user form
    By s_samira_21 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-11-2014, 12:44 PM
  3. Print From user form.
    By leoruphen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2014, 02:15 PM
  4. Print User Form
    By kachuen2006 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-30-2014, 04:35 PM
  5. 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
  6. Print scrollable user form.
    By cparsons in forum Excel General
    Replies: 2
    Last Post: 08-04-2005, 12:05 PM
  7. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1