Working with Excel Forms

Introduction

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.