Office® XP Development with VBA

Creating a User Form

A User Form consists of the form itself (the screen window) plus the specific controls that were placed on the form. Each User Form is represented by a UserForm object, and all of the User Forms that are loaded as part of a project are contained in the UserForms collection. Every User Form has a set of properties that control various aspects of its appearance and behavior, such as color, size, and borders. All of the controls on a User Form are represented in the Controls collection. Each control, has a unique name and its own set of properties. Each control, as well as the User Form itself, has a set of events, such as mouse clicks and key presses, that can be detected automatically. A User Form can contain sub- and function ...