How is automation coding structured?

Understanding automation : How is automation coding structured?

How is automation coding structured?

Your programming knowledge should help you learn to automate the software, regardless of your level of experience with Microsoft Visual Basic for Applications (VBA) or Microsoft Visual Studio Tools for Applications (VSTA).

In this topic

This topic contains the following subtopics:

•

Declaring variables

•

Using functions and subroutines

•

•

•

•

•

Using Boolean comparison and assignment

•

Using logical and bitwise operators

•

Providing message boxes and input boxes

•

Referencing objects

•

Referencing collections

•

Using object shortcuts

•

Providing event handlers

•

The Macro Editor formats all VBA coding for you (see Formatting code automatically). The only way to customize the formatting is to change the size of the indentations.

•

VBA can be used to create object-oriented classes. However, this function is a feature of the programming language and is therefore not discussed in detail in this documentation.