Chapter 3. Excel and VBA Development Best Practices

This chapter appears early in the book because we want you to understand why we do certain things the way we do in later chapters. Unfortunately, this also means we’ll have to cover a few topics in this chapter that don’t get full coverage until later. For best results, you may want to review this chapter after you’ve read the rest of the book.

As you read this chapter, you should also keep in mind that even though the practices described here are generally accepted best practices, there will always be certain cases where the best thing to do is not follow the best practice. We try to point out the most common examples of this here and in the best practices discussions in the chapters that follow. ...

Get Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Second Edition 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.