Form initialization

Before we begin to use forms we need to initialize them. This means adding a set of values to the controls and setting the default values. Initializing values is done in the subroutine from which we start the the Form. Show method to display the form. After it opens, the user will be able to enter the desired values, and most importantly, it will be able to select the values instead of always input them as plain text.


Forms are graphic objects that are created by the designer, and they consist of a variety of controls for easier data entry. These may be: text input field, radio buttons, check boxes, drop-down lists, combined lists, etc. By adding control to the mask, prerequisites for retrieving values into a document ​​are created, and after the scheduled action they are imported on specific location within a worksheet.

VBA objects

VBA uses objects to control Excel behavior so if you want to master this programming language and make the most of it you need to get acquainted with objects and collections, as well as with their properties and methods. In this text, I will introduce you to the most frequently used Excel objects: Application, Workbooks, Worksheets, Cells … In some of the following articles, we will deal more closely with each of them.


Excel has a large number of objects, and the VBA allows us to easily create and manipulate them. We can declare variable as an object by specifying the variable name and the object name as a type. Then, using the Set command, we assign the actual object to a variable. Once this is done, we can change its properties or run methods – subroutines that allow further manipulation of objects.

With structure

When we declare a variable as an object or custom data type we can access its members in many ways. In the opinion of many, the easier way is to individually “frame” the object fields by the With structure. Instead of dividing the variable and field name by the „points“, it allows us to define a block of commands, enter values by specifying field names, and then closing a block that completes the value assignment process.