From the course: Excel VBA: Managing Files and Data

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Create a UserForm

Create a UserForm

From the course: Excel VBA: Managing Files and Data

Start my 1-month free trial Buy for my team

Create a UserForm

“

- One issue that Excel VBA developers always face is how to allow for user input. If you give users direct access to every worksheet, then they can change data they're not supposed to, either by accident or on purpose. Also, they might discover data that you would rather keep hidden. With this movie, I will show you how to create and use user forms, which allow user input, but without direct access to worksheets. My sample file is 06_01_CreateUserForm, and you can find it in the Chapter 6 folder of the Exercise Files collection. We won't be using any of the data on the Sheet 1 worksheet, so I'll press Alt + F11 to move to the Visual Basic Editor. I don't have any code modules created yet, but I can create a user form. To do that, I'll go up to the Insert menu, and then the first available item is User Form, so I'll click that. And I get a user form displayed for me, as well as the toolbox with controls that I can add. We will get to the controls in the toolbox individually later in…

Contents