Excel® 2013 On Demand

Enhancing a Workbook with VBA

Office programs like Excel, Access, Word, PowerPoint, and Visio share a common programming language: Visual Basic for Applications (VBA). With VBA, you can develop applications that combine tools from these Office products, as well as other programs that support VBA. Because of the language’s power and flexibility, programmers often prefer to use VBA to customize their Office programs.

Introducing the Structure of VBA

VBA is an object-oriented programming language because, when you develop a VBA application, you manipulate objects. An object can be anything within your workbook, such as a shape, text box, picture, or table. Even Excel itself is considered an object. Objects can have properties that describe the ...