A computer application, such as those that run on
Microsoft Windows, is equipped with objects called Windows controls. These
are the objects that allow a person to interact with the computer.

The primary control used on most applications is
called a form.

Practical
Learning: Introducing Forms

Start Microsoft Excel

On the Ribbon, click Developer

In the Code section, click Visual Basic

Creating a Form

To create a form, on the main menu of Microsoft Visual Basic,
you can click Insert -> UserForm. This would add a form to your
project. In the same way, you can add as many forms as you want.

The form is primarily used as a platform on which you
add other controls. For this reason, a form is referred to as a container.
By itself, a form is not particularly useful. You should add other objects
to it.

When you create or add a form, a module is also
automatically created for it. To access the module associated with a form,
you can right-click the form and click View Code.

Practical
Learning: Creating a Form

To create a form, on the main menu, click Insert -> UserForm

To access its associated module, right-click the form and click View Code

To return to the form, on the main menu, click Window and click the menu
item that has (UserForm).

Using a Form

Showing a Form

Although you create a form in Microsoft Visual Basic,
you view its results in Microsoft Excel. You have various options.

A form is referred to as modal if the user cannot
access anything from the same application while the form is displaying. A
form is called modeless if the user can click something of the same
application behind that form while the form is displaying.

To display the run-time view of a form in modal view:

While in Microsoft Visual Basic, you can press F5

On the main menu of Microsoft Visual Basic, you can click Run ->
Run Sub/UserForm

On the Standard toolbar of Microsoft Visual Basic, you can click the
Run Sub/UserForm button .
This would send the form to Microsoft Excel and display it in the
normal view

You can also programmatically display a form. To
support this, the UserForm object is equipped with a method named Show.
Its syntax is:

Public Sub UserForm.Show(Optional ByVal Modal As Boolean)

This method takes one Boolean argument that is
optional. If you omit it, the form would display as modal and the user
cannot do anything else in Microsoft Excel as long as the form is not
closed. That's the default behavior. If you want to display the form as
modeless, pass the argument as False. Here is an example:

Private Sub Exercise()
UserForm1.Show False
End Sub

Printing a Form

If you have equipped a form with many aesthetic
objects you want to see on a piece of paper, you can print it. To support
printing, the UserForm object is equipped with a method named PrintForm.
Its syntax is:

Public Sub PrintForm

This method takes no argument. When called, it sends
the (body of the) form directly to the printer. Here is an example of
calling it:

Private Sub Exercise()
UserForm1.PrintForm
End Sub

Hiding a Form

As opposed to displaying a form, if it is already
showing, you can hide it. To allow you to hide a form, the UserForm object
is equipped with a method named Hide. Its syntax is:

Pyblic Sub UserForm.Hide

This method takes no argument. When called, it hides
the form (without closing it). Here is an example of calling it:

Private Sub Exercise()
UserForm1.Hide
End Sub

Closing a Form

After using a form, the user can close it by clicking
the system close button. To programmatically close a form, use the End
statement. Here is an example:

Private Sub Exercise()
End
End Sub

The Characteristics of a Form

The Name of a Form

Like every object on a computer, the primary
characteristic of a form is its name. After creating a form, access its
Properties window, click (Name), type the desired name and press Enter

Practical Learning:
Naming a Form

If the Properties window is not displaying, right-click the form and click
Properties window.

In the Properties window, click (Name) and type
frmCleaningOrders

The location of a Form

When a form displays in normal view to the user, it is
usually centered. The user can then drag its title bar to move it around.
You too can move a form.

If you want to specify the position a form would
assume when it displays, at design time, access its Properties window.
Then change the values of the Left and the Top properties. You can also
programmatically control the location of a form. You have two options. You
can assign the desired values to its Left and/or Top
properties. Here is an example:

Private Sub Exercise()
UserForm1.Left = 400
End Sub

Al alternative is to call the Move method. Its
syntax is:

Public Sub UserForm.Move(ByVal Left As Single, ByVal Top As Single, Optional ...)

This method takes two required arguments. The first
represents the left distance and the second is the top distance. Here is
an example:

Private Sub Exercise()
UserForm1.Move 200, 200
End Sub

The Size of a Form

When you have just added a new form, it assumes a
default size. If that size doesn't fit your intentions, you can change.

To change the size of a form, you can access its
Properties window. Then change the values of the Height and Width. To
programmatically change the size of a form, you have many options. You can
assign the desired values to its Height and/or to its Width. Here is an
example:

Private Sub Exercise()
UserForm1.Width = 600
End Sub

Another option is to call the Move method. In reality,
this method takes two required arguments and two optional arguments. Its
actual syntax is:

Public Sub UserForm.Move(ByVal Left As Single, ByVal Top As Single, _
Optional ByVal Width As Single, Optional ByVal Height As Single)

The last two optional arguments allow you to specify
the size of the form. Here is an example:

Private Sub Exercise()
UserForm1.Move 200, 200, 1040, 600
End Sub

Practical Learning:
Resizing a Form

Position the mouse in the lower-right section of the form

Click and drag right and down

Return to Microsoft Excel

To close Microsoft Excel, click the Office Button and click Exit Excel