In the application I am working on, a folder is selected with no more than 20 files in it. These files are all then modified, and the charts are copied into powerpoint as well as various tables created from each file.
What I need to do is to create a userform which can have two dynamic drop down menus containing all the file names from the selected folder. What I would like to do, if possible, is have dynamic userform dimensions which change based on the number of files in the folder, and check boxes with each of the file names.
From there, I just need to overlay the charts from the files chosen by the user. My initial idea on this is to create a new workbook, copy all the user-defined charts into the workbook, then merge all the data into one chart which is then pasted into powerpoint. There may be an easier way to do this, and I'm always open to ideas.
Bookmarks