VBA Training Series – How to Create a Userform (Part 3 of 3)

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.zip

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

Intro to VBA:
Writing Your First Macro

Automating Tasks:
The Summary Report

Video 3

The Exports Sheets App

How features can we add to the userform?

Please leave a comment below with your answer, and any questions.  Thanks!


Your email address will not be published. Required fields are marked *

  • 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!

  • 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