+ Reply to Thread
Results 1 to 3 of 3

Print to PDF from listbox

  1. #1
    Forum Contributor
    Join Date
    08-10-2017
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    132

    Print to PDF from listbox

    Hi,

    Just wondering if anyone is able to help.

    I currently have a userform and in that a listbox that displays my worksheets and a few command buttons to add or remove worksheets to another listbox.

    From there i have a print preview button that seems to work fine.

    I am wondering is it possible to add another command button to print to pdf the worksheets that are in my second listbox as one single document?

    If this is possible is anyone able to steer me in the right direction how I can achieve this.

    I have attached a template

    Thanks in advance for any help.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,029

    Re: Print to PDF from listbox

    cycle thru the listbox putting the sheets in an array,
    which selects all sheets in it,
    then print:

    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,859

    Re: Print to PDF from listbox

    Hi bruno,

    It's good to see that you are using 'Option Explicit'. Very important.

    Try:
    Please Login or Register  to view this content.
    Lewis

+ 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 Print Listbox
    By RJ1969 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2019, 01:13 AM
  2. Print Multiple Sheets from a Listbox on a UF as one Print Job
    By craigos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2014, 06:46 AM
  3. Print items from a listbox
    By rcprito in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-29-2013, 06:42 AM
  4. userform listbox
    By tsiguy96 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-14-2013, 11:09 PM
  5. Print ListBox
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-09-2012, 02:19 PM
  6. Print from Listbox
    By TBrooker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2009, 07:27 AM
  7. Print A Listbox
    By mikewild2000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2005, 06:39 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