Print to PDF from listbox

[bruno2580]

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.

[ranman256]

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.

[LJMetzger]

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