Chapter 23. VBA Primer

In this chapter, you will:

  • Explore the benefits of working with VBA code

  • Learn how to read and understand VBA code

  • Discover the core basics of how to write your own macros

  • Get tips and guidance on ways to apply VBA basics for accomplishing a wide range of tasks

If you have any concerns about venturing into this chapter, take a deep breath and relax. You’ll be perfectly comfortable here. This thorough primer on Microsoft Visual Basic for Applications (VBA) is written for advanced Microsoft Office users, not for programmers.

I’m not a programmer, so I won’t treat you like one. The fact is that you don’t have to be a programmer to make effective use of VBA (or Office Open XML, as discussed in Chapter 24). Yes, I use VBA and Office ...

Get Documents, Presentations, and Workbooks: Using Microsoft® Office to Create Content That Gets Noticed 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.