• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 30. Creating Interactive Excel A... > Introduction to Object-Oriented Prog...

Introduction to Object-Oriented Programming

VBA is a structured programming language just like English is a structured communication language. English sentences are constructed of building blocks such as nouns, verbs, and adjectives; VBA sentences (called statements) are constructed of building blocks such as objects, methods, and properties. English sentences are grouped in larger blocks of related information called paragraphs; similarly, VBA statements are grouped in larger blocks called procedures. A procedure is a set of VBA statements that performs a specific task or calculates a specific result. If you want to learn how to construct VBA statements and procedures, you first must learn more about the building blocks. This section provides some background information on VBA's building blocks.

Objects

VBA is an object-oriented programming language. Excel is made up of a series of objects that you can manipulate through code. Think of some of the objects that make up your office. You probably have a desk, chair, computer, and telephone. You use these objects to complete the various tasks that your job requires.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint