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:
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!
Hello Jon,
The three videos are fantastic!
But I have a problem with choosing the ListBox after ME because it is not exist in the list after the “DOT”, however I wrote it but the result was an error!!
So please help me.
Thanks in advance.
Hi Jon
I volunteer at a Emergency Food Relief organization in Australia and all of our record-keeping is done through Excel. One of the often unacknowledged benefits of macros is that even someone with just a little familiarity with Excel can press a Ctrl-Shift-J to complete a fairly involved task. Your three videos hit me pretty much where I am at at the moment with the tasks I am working on. So thanks!
Very insightful!Thank you
what would be the code to copy the selected worksheets to one workbook?
How is anyone supposed to open the workbook when it looks like this:
Download the file used in this video: [wpfilebase tag=file id=68 tpl=simple /]
Can’t even do the video without that, just like video 2.
Is this website totally old and outdated and never used anymore? Seems like the owner has just let it go or something. I couldn’t trust the paid stuff when the simple free stuff doesn’t work. Or maybe the free stuff doesn’t work so that you’ll pay for the other stuff? Either way, not a good look