Use Checkbox Userform to select worksheets and save to PDF

[alistairmcquat]

Hi,

I am brand new to the forum and vba, so be nice

I have already created a Userform to select worksheets to print but what i'm struggling with is to create a userform to select what ever worksheets are required and save as PDF (multiple or as one-doesn't particularly matter).

Saved PDF file to be saved within the same folder as the excel file, with same name but "todays" date.

Don't want to be cheeky, but as a bonus, would it be possible to add an option that once saved you can choose whether to print the saved pdf? (not essential as i have the userform to print).

I have spent days looking online but nothing seems to quite work. Ive seen a couple of threads on here, but they don't seem to deal with it/or my knowledge isn't great enough to amend to suit...probably the latter! I got close, but it would only save the first sheet selected in the checkbox.

Thanks in advance for your help.

[jaslake]

Hi alistairmcquat

Welcome to the Forum!!!

In order for us to assist, please attach a sample workbook the Structure of which is the same as your actual workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

INCLUDE ANY CODE YOU'RE USING OR HAVE TRIED.

Remember to desensitize the data.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

[mehmetcik]

Please Login or Register  to view this content.

[bakerman2]

@ mehmetcik

Just some info

Please Login or Register  to view this content.

This isn't really needed because when exporting the extension is automatically added.

[mehmetcik]

Thanks

Never tried exporting before.

[alistairmcquat]

Hi thanks for the replies.
As i mentioned im pretty new (brand new) to vba. Tried the listbox above, but how do you get certain worksheets to save as pdf?

going back to my original post/query, below is the code ive got to print multiple selected sheets, is there a way to tweek this to suit? Ive tried to upload the file, but the attachment button doesnt seem to want to work for me right now.
Its a simple excel workbook with 20 worksheets (this will increase). I have a main worksheet where all the infomation is inputted and cascaded through teh other sheets. I then need a "PDF" button that pops up a list of all the worksheets, so you can select which ones you require and then save as pdf.

Ill try and upload the file late.

Please Login or Register  to view this content.

This is the above code i tried to tweek to save as pdf, but it only manages one sheet then complains.

Please Login or Register  to view this content.

[mehmetcik]

Ok

I have attached a few sample Userforms for you.

[alistairmcquat]

Thank you, ill have a wee look at them today and get back to you.

[alistairmcquat]

Thanks for all the help, but its clear my knowledge is sooo green that none of the help is making any serious sense....i also still cant upload the file

[alistairmcquat]

ok, i think im getting there.

I am struggling with this bit of code though, keeps popping up with a "424" error, object required when i press the command button. What am i missing?

Please Login or Register  to view this content.

[bakerman2]

To upload workbook check this out.
Post#1 - method2.
https://www.excelforum.com/the-water...his-forum.html

[mehmetcik]

Try this version.

I have modified it to avoid that line of code.

[frankeardley]

Mehmetcik

Your sample above is exactly what i am looking for, to be able to select which worksheets I want to PDF,
However I have one request, on sheet 1 I have a quote generator which works quite nicely, however depending on the type of customer I have different terms and conditions and customer requirements on worksheet 2 to 5
What i would love to do is when I hit your Button 1 "export as PDF" that it prints worksheet 1 and the corresponding selected worksheets into one nice PDF, rather than multiple ones,

Thanks for the help

Frank

[bakerman2]

Hi Frank, welcome to the forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.