This page has 0 threads | Add post

Finding our blogs useful? Please consider helping us to share more!

Looping in Visual Basic for Applications macros Part one of a four-part series of blogs
There are 4 types of loop in Visual Basic for Applications - this blog shows how and when to use each type of VBA loop structure. Looping in VBA Macros (this blog) Looping N times (FOR ... NEXT) Looping with conditions (DO UNTIL / WHILE ... LOOP) Looping over collections (FOR EACH ... NEXT) This series of blogs is part of our Excel VBA online tutorial. We also run training courses in Excel and VBA.

Looping in Visual Basic for Applications macros

Part one of a four-part series of blogs

There are 4 types of loop in Visual Basic for Applications - this blog shows how and when to use each type of VBA loop structure.

Looping in VBA Macros (this blog)
Looping N times (FOR ... NEXT)
Looping with conditions (DO UNTIL / WHILE ... LOOP)
Looping over collections (FOR EACH ... NEXT)

This series of blogs is part of our Excel VBA online tutorial. We also run training courses in Excel and VBA.

Posted by Andy Brown on 15 November 2011

Looping in VBA Macros

There are essentially three types of loop that you can write in Visual Basic for Applications:

Use FOR ... NEXT when you want to loop a given number of times.
Use DO UNTIL ... LOOP when you want to loop until a condition is true, or the very similar DO WHILE ... LOOP or WHILE ... WEND when you want to loop while a condition is true.
Use FOR EACH ... NEXT when you want to loop over the objects in a collection.

These are in ascending order of usefulness. If you're an experienced VBA programmer, looping over the objects in a collection is nearly always the way to go.

The rest of this blog gives examples of each type of loop, with the possible forms of syntax. You can also learn about looping in VBA on our two-day introduction to VBA course and (in more detail) on our two-day advanced VBA course.

Parts of this blog
Looping in VBA Macros (this blog) Looping N times (FOR ... NEXT) Looping with conditions (DO UNTIL / WHILE ... LOOP) Looping over collections (FOR EACH ... NEXT)

Some other pages relevant to the above blogs include:

This blog has 0 threads

Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

Site map

Terms & Conditions

Book any course as classroom, onsite or online training, or as one-to-one consultancy

Free resources

Paid services

Getting help

Where we are

Where you are

Online

Transparent reviews

Delivery of courses

Nicer to work with

Reliable and established

Our training courses

C#

Excel

Google Sheets

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

BLOGS BY TOPIC

BLOGS BY AUTHOR

Looping in VBA Macros

Head office

London

Manchester