Excel VBA Macros exercises on LOOPING OVER COLLECTIONS

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

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

Go to exercise ...

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

Go to exercise ...

Software: Excel VBA Macros
Version: Any version of Excel
Topic: Looping over collections
Level: Average difficulty
Course: Excel VBA macros
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.

Go to exercise ...

Software: Excel VBA Macros
Version: Any version of Excel
Topic: Looping over collections
Level: Average difficulty
Course: Excel VBA macros
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).

Go to exercise ...

Software: Excel VBA Macros
Version: Any version of Excel
Topic: Looping over collections
Level: Average difficulty
Course: Excel VBA macros
Exercise: Use For Each loops to split a single table of data into three separate worksheets.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Software: Excel VBA Macros
Version: Any version of Excel
Topic: Looping over collections
Level: Harder than average
Course: Excel VBA macros
Exercise: Loop over all of the continent worksheets in a world workbook, going to the bottom cell on each, extracting the capital city name and listing on a separate sheet.

Go to exercise ...

Software: Excel VBA Macros
Version: Any version of Excel
Topic: Looping over collections
Level: Harder than average
Course: Excel VBA macros
Exercise: Create macros to play hangman and to fill in a word search - two exercises in one!.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

You can search our full list of VBA exercises here, or why not have a look at our other VBA training resources?

This page has 0 threads Add post