From the course: Excel VBA: Managing Files and Data

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Run a UserForm

Run a UserForm - Microsoft Excel Tutorial

From the course: Excel VBA: Managing Files and Data

Start my 1-month free trial

Run a UserForm

“

- [Instructor] After you create a User form using VBA, you can use other VBA commands to display the form, and also to hide it. In this movie, I will show you how to use those commands. My sample file is 06_10 RunUserform. And that is a macro-enabled Workbook that you can find in the chapter six folder of the exercise files collection. This workbook contains a single worksheet and it is ready to accept data from my User form. So I'll switch over to VBA by pressing Alt + F11, to display the visual basic editor. And you can see here that I have a form to take in customer information and in the back, there's a code module with the sub-routine named RunUserForm. We'll get to that in a second. My goal is to create a VBA sub-routine that I could run by clicking a command button or some other control that will display this customer information form. Before I can create that sub-routine however, I need to know the name of the form.…

Contents