Hi folks,
I want to build a PDF print out function that considers the user's input into a userform.
Basically I got 2 worksheets (CW and Year), each containing 10 charts, with each chart on one page (in terms of print area).
Now I want the user to be able to chose the charts to be printed, either as individual files or all together in one PDF.
This is, how the UserForm looks like:
RwxOE.png
If the user choses to save the charts as individual PDFs, she should be prompted only once for the location to save the PDFs to. The tabs on the form "CW" and "Year" are basically the same, but only refer to 2 different worksheets. The tab "Filter" only contains a single choice.
I tried creating an array (charts vs. pages) with charts correspond to the CheckBoxes. So if chart "Units, Performance, KPI and Region South" are selected, it'll look like ({1,1}, {0,2}, {1,3}, {1,4}, {0,5}, {0,6}, {0,7}, {1,8}, {0,9}, {0,10}) - never mind the format - with {#,..} being true or false, depending on the user's choice, and {..,#} being the corresponding page number of the charts.
However, with that approach I'm running into 2 problems: a) reseizing the array to all true values being equal to ({1,1}, {1,3}, {1,4}, {1,8}). That would tell, which pages to print. And, problem b) is that the command
only allows to input a page range (
) but not the individual pages.
What's your idea on solving this issue? Any best practicess or another work around?
Thanks for your effort in advance!
Bookmarks