Home / MS-Excel / General Formatting

Working with Objects

Many of your VBA procedures will perform calculations using simple combinations of numbers, operators, and the host application's built-in functions. You'll probably find, however, that most of your code manipulates the application environment in some way, whether it's formatting document text, entering data in a worksheet range, or setting application options. Each of these items-the document, the range, the application-is called an object in VBA. Objects are perhaps the most crucial concept in VBA programming, and I will explain them in detail in this tutorial.