Excel® 2010 Power Programming with VBA

Chapter 11: VBA Programming Examples and Techniques

IN THIS CHAPTER

• Using VBA to work with ranges

• Using VBA to work with workbooks and sheets

• Creating custom functions for use in your VBA procedures and in worksheet formulas

• Trying miscellaneous VBA tricks and techniques

• Using Windows Application Programming Interface (API) functions

Learning by Example

I believe that learning programming concepts is accelerated by a heavy emphasis on examples. And based on the feedback that I've received from readers of previous editions of this book, I have plenty of company. VBA programmers especially benefit from a hands-on approach. A well-thought-out example usually communicates a concept much better than a description of the underlying theory. I decided, therefore, not to write a reference book that painstakingly describes every nuance of VBA. Rather, I prepared numerous examples to demonstrate useful Excel programming techniques.

The previous chapters in this part provide enough information to get you started. The Help system provides all the details that I left out. In this chapter, I pick up the pace and present examples that solve practical problems while furthering your knowledge of VBA.

I've categorized this chapter's examples into six groups:

• Working with ranges

• Working with workbooks and sheets

• VBA techniques

• Functions that are useful in your VBA procedures

• Functions that you can use in worksheet formulas

• Windows API calls

Subsequent chapters in this book ...