Closed Thread
Results 1 to 7 of 7

Need vba code to print specific pages or all pages in a multipage UserForm

  1. #1
    Forum Contributor
    Join Date
    10-03-2015
    Location
    Jamaica
    MS-Off Ver
    2013
    Posts
    120

    Need vba code to print specific pages or all pages in a multipage UserForm

    Good day all,

    As the topic suggested I would like a line of code which will allow me to print a specific page from a multipage UserForm or print the entire form (all pages) when click commandbutton I created

    Assistance in this regard would be greatly appreciated.

    I would also like a line of code which will clear all textboxes in a userform when I click the commandbutton I created.

    Thanks

    Please see attached the link to a the same query made on another similar forum

    http://www.mrexcel.com/forum/excel-q...-userform.html
    Last edited by Pimp_mentality; 11-04-2015 at 12:59 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Need vba code to print specific pages or all pages in a multipage UserForm

    Attaching a sample workbook enables others to work on your problem:

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    To add a file to a new post

    To add a file to an existing post.

  3. #3
    Forum Contributor
    Join Date
    10-03-2015
    Location
    Jamaica
    MS-Off Ver
    2013
    Posts
    120

    Re: Need vba code to print specific pages or all pages in a multipage UserForm

    Oh You are correct sir, sorry for the oversight

    attached is an example of what i am referring to

    Thanks
    Attached Files Attached Files

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,855

    Re: Need vba code to print specific pages or all pages in a multipage UserForm

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Forum Contributor
    Join Date
    10-03-2015
    Location
    Jamaica
    MS-Off Ver
    2013
    Posts
    120

    Re: Need vba code to print specific pages or all pages in a multipage UserForm

    Ok sir, I was not aware and now that it is explained it actually makes a ton of sense. My apologies. there will be no re-occurrence.
    Last edited by Pimp_mentality; 11-04-2015 at 01:01 PM.

  6. #6
    Registered User
    Join Date
    02-24-2020
    Location
    Bonn, Germany
    MS-Off Ver
    10
    Posts
    2

    Re: Need vba code to print specific pages or all pages in a multipage UserForm

    is it posible to send all userform multipages as pdf or pics to a mail attachment

  7. #7
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,855

    Re: Need vba code to print specific pages or all pages in a multipage UserForm

    @pioneerjack

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change color for pages in multipage on userform
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2015, 03:27 PM
  2. VBA code to print and save specific pages in excel sheets?
    By JPSIMMON in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2014, 03:05 PM
  3. [SOLVED] Change background image on individual multipage userform pages using vba
    By sbrennan970 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2013, 06:50 AM
  4. Select specific MultiPage in a UserForm with other pages grayed out
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-04-2012, 02:56 PM
  5. Opening specific multipage pages with button
    By andy.allard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2009, 11:59 PM
  6. Replies: 2
    Last Post: 02-24-2009, 03:52 PM
  7. Copying Multipage Pages and related code
    By jagman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-22-2009, 07:33 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