[ Team LiB ] Previous Section Next Section

Workshop

The Workshop includes quiz questions that are designed to help you test your understanding of the material covered and activities to help put what you've learned to practice. You can find the answers to the questions in the section immediately following the quiz.

Quiz

1:

What does VBA stand for?

A1:

Visual Basic for Applications.

2:

Name the two units in VBA code.

A2:

Subroutine and function.

3:

Standard modules are associated with a form or report (True/False).

A3:

False. Class modules are associated with a form or report.

4:

Name three variable scopes.

A4:

Local, Private, and Public.

5:

What character do you use to add a comment to code?

A5:

An apostrophe.

Activities

Practice creating a standard module. Add a subroutine to that module. Create a new form. Add a command button to the form. Use the Click event behind the command button to execute the subroutine that you added to the module.

    [ Team LiB ] Previous Section Next Section