LOOPING OVER COLLECTIONS exercises

This page lists the 11 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:	Use For Each loops to split a single table of data into three separate worksheets.

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