Chapter 7. Control Visual Basic

Chapter at a Glance

image with no caption

In this chapter, you will learn to:

  • Use conditional statements.

  • Create loops using three different blocks.

  • Retrieve the names of files in a folder.

  • Create breakpoints to debug long loops.

  • Show progress while a macro executes a loop.

The first successful underwater tunnel ever built was begun in 1825. It is the Thames Tunnel. It was a financial disaster at the time, but amazingly it is still in use as part of the London Underground system. The genius behind the the tunnel’s engineering was a man named Marc Brunel. Twenty years before launching the Thames Tunnel, Brunel made a name for himself by devising ...

Get Microsoft® Offic Excel® 2007 Visual Basic® for Applications Step by Step 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.