Cells and ranges manipulation

Range and Cells objects are used to manipulate Excel ranges and cells. These objects have many useful properties and methods that can affect the content and formatting of individual cells or ranges within a worksheet, whether the active ones or those which we explicitly specify. VBA allows you to manipulate individual cells, ranges or named ranges …

Worksheets and Sheets

Worksheets and Sheets are object collections that are identical with a few small exceptions. Their task is to manipulate objects within a worksheet, and which one we’ll use is often a matter of personal choice. In the text that follows you will become familiar with the most commonly used properties and methods that allow counting, adding, changing names and other tools for manipulating worksheets.

Workbooks

This collection allows you to work with a variety of subordinate objects, change properties, and run methods for manipulating workbooks. Further it allows you to add new, open, save, close the workbooks… It also enables the opening of external links, document protection and all other operations to control workbooks in order to improve the experience of working in Excel.

Application object

Application object is the highest by hierarchy among VBA Excel objects. It has a host of subordinate objects as well as about 170 properties that can influence application behavior. Objects generally have many properties and there is no need to remember each one of them, we should only remember the most important ones that we will use in our day-to-day work. The following is an overview of the most important properties of the Application object.

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.