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 ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.