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.

Create a UserForm

Create a UserForm - Microsoft Excel Tutorial

From the course: Excel VBA: Managing Files and Data

Start my 1-month free trial

Create a UserForm

“

- One issue that Excel VBA developers always face, is how to allow user input. If you give users direct access to the workbooks and worksheets, then they can change data that perhaps they're not supposed to. Or they could see data that is confidential. In this movie, I will start to show you how to create and use user forms, which allow user input but without direct access to worksheets. for this movie I will use the sample file named O6O1 create user form. 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. We're actually not going to use any data on it. So I'll press alt F11 to move directly to the visual basic editor. I don't have any code modules set up. Instead, What I want to do is create a new user form. So I will go to the insert menu and click the first highlighted item for me, which is…

Contents