Skip to Main Content
Business Solutions VBA and Macros for Microsoft® Office Excel® 2007
book

Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

by Bill Jelen, Tracy Syrstad
August 2007
Beginner to intermediate content levelBeginner to intermediate
624 pages
14h 46m
English
Que
Content preview from Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 5. Looping and Flow Control

IN THIS CHAPTER

Loops are a fundamental component of any programming language. If you’ve taken any programming classes, even BASIC, you’ve likely encountered a For...Next loop. Luckily, VBA supports all the usual loops, plus a special loop that is excellent to use with VBA.

This chapter covers the basic loop constructs:

  • For...Next

  • Do...While

  • Do...Until

  • While...Loop

  • Until...Loop

We also discuss the cool loop construct unique to object-oriented languages:

  • For Each...Next

For...Next Loops

For and Next are common loop constructs. Everything between For and Next is run multiple times. Each time that the ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Business Solutions VBA for the 2007 Microsoft Office System

Business Solutions VBA for the 2007 Microsoft Office System

Paul McFedries

Publisher Resources

ISBN: 9780789736826Purchase book