Macros & VBA Training Series Part 3:
How to Create a Userform to Export Worksheets
Double-click video to view in Full Screen HD.
Download the file used in this video:
The Exports Sheets Userform.xlsm (216.4 KB)
Bonus: How to Export The Selected Items Only
In this video I explain how to set the listbox multiselect property to allow the user to select multiple items. We then add code to the Export button’s Click event to only export the selected sheets. We do this with an IF statement.
Macros & VBA Training Series
How features can we add to the userform?
Please leave a comment below with your answer, and any questions. Thanks!