Working with Excel Forms
The "Working with Excel Forms" module provides you with the instructions and devices to develop your hands on skills in the following topics: Creating a Form to Get User Input.
The Working with Excel Forms module provides you with the instructions and devices to develop your hands on skills in the following topics.
- Creating a Form to Get User Input
Lab time: It will take approximately 60 minutes to complete this lab.
Exercise 1 - Creating a Form to Get User Input
You can create userforms, or simply "forms," when you want to get various kinds of input from users, and use VBA to take actions according to that input.
You will learn:
- About userforms and how they work
- About the various kinds of controls you can add to a userform
- How to set properties of userforms and controls
- How to edit VBA code associated with controls on a userform
In this exercise, you will create a very simple form, place two controls on it, and then program a button to move text from a text box to a cell on the active worksheet. It's not the most realistic demonstration of a form, but it shows several of the basics you'll need if you go on to program more useful forms.
IT & Cybersecurity certification hands on practice labs and practice exams for certifications and skill development.
See the full benefits of our immersive learning experience with interactive courses and guided career paths.