Hi,
I have a Forms Command Button w/ a Macro that copy/paste specific variables and range in the workbook to a pre-defined PowerPoint template file (in the same directory as the workbook file).
This macro works but I would like the user to select from a check box window the Graphs or Tables from the Worksheets. The selection would drive the cut/paste to PowerPoint. Any ideas?
Thanks in advance.
You need to create a userform that lists the available graphs and tables.
You can use the shapes collection to loop through all the shapes on a sheet.
Check their type and only add charts/tables to the listbox.
Give the listbox Multiselect property and option style. This will give each item in the list a checkbox.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks