Chapter 3. Tasks in Visual Basic

Once you’re comfortable recording and changing code in Excel and you’re familiar with the structure of a Visual Basic program, you can focus your effort on doing real work with your programs. By real work, I mean: performing calculations, composing text, comparing dates and times, and accomplishing the other tasks provided by the Visual Basic language.

As with Chapter 2, most of the tasks I cover here are not unique to Excel, and if you learn them well, you can use these skills to program Word, PowerPoint, or even Windows itself. This chapter is the companion to Chapter 2; between the two chapters you’ll learn most of what you need to know about the Visual Basic programming language.

Tip

Code used in this chapter and additional samples are available in ch03.xls.

Get Programming Excel with VBA and .NET 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.