If you see a property in the “Property Sheet” of a user interface object, it is accessible from any event handler of any user interface object in the same form. In other words, within the same form, event handlers of user interface objects can access the properties of each other. A “Form” is an important concept in interactive VBA programming because it is a container that defines the scope of properties of contained objects.
This also means that it is okay to use the same name for objects that belong to different forms. For example, two forms can each have a button named “confirmButton” because each cannot see the other one in the other form.
What if you need two forms to communicate with each other, or share a common value? It is best to use a module as the intermediate container. This is because properties of a module can be visible to all forms.