This page has 0 threads | Add post

Exercises

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

Excel VBA Macros exercises on LOOPING OVER COLLECTIONS

This page lists the 10 exercises about Looping over collections in Excel VBA Macros on our website:

Software:	Excel VBA Macros
Topic:	Looping over collections
Level:	Relatively easy
Exercise:	A macro to loop over shapes on a worksheet changing their line colour - lots of hints given.

Show this exercise

Software:	Excel VBA Macros
Topic:	Looping over collections
Level:	Average difficulty
Exercise:	A macro to loop over the 100 x 100 grid that is Wimbledon Common and find and report on all of the Wombles found (ie the non-blank cells).

Show this exercise

Software:	Excel VBA Macros
Topic:	Looping over collections
Level:	Average difficulty
Exercise:	Change a team strip from green to (eg) red by looping over all of the cells in a range.

Show this exercise

Software:	Excel VBA Macros
Topic:	Looping over collections
Level:	Average difficulty
Exercise:	Loop over all of the cells in a block, creating a psychedelic pattern to resemble Elmer the elephant.

Show this exercise

Software:	Excel VBA Macros
Topic:	Looping over collections
Level:	Average difficulty
Exercise:	Write VBA code in Excel to loop over a collection of cells to pick a set of six random numbers to use in a lottery.

Show this exercise

Software:	Excel VBA Macros
Topic:	Looping over collections
Level:	Harder than average
Exercise:	Create a game of hangman in VBA, to include lots of functions.

Show this exercise

Software:	Excel VBA Macros
Topic:	Looping over collections
Level:	Harder than average
Exercise:	Create a macro to fill in a word search.

Show this exercise

Software:	Excel VBA Macros
Topic:	Looping over collections
Level:	Harder than average
Exercise:	Generate unique hands of cards to deal a poker game in Excel.

Show this exercise

Software:	Excel VBA Macros
Topic:	Looping over collections
Level:	Harder than average
Exercise:	Loop over a set of mortgage deals and create an output file which compares them.

Show this exercise

Software:	Excel VBA Macros
Topic:	Looping over collections
Level:	Harder than average
Exercise:	Loop over all of the continent worksheets in a world workbook, copying the bottom cell of each worksheet.

Show this exercise

You can search our full list of VBA exercises here. Or why not learn to do them the right way on one of our VBA training courses? You can attend our online training classes wherever you are in the world!

None of the exercises or supporting files may be copied in any form or used commercially without the prior written permission of Wise Owl (although you're welcome to use them for testing your own knowledge).

This page 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

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

EXERCISE TOPIC

VBA EXERCISES