Microsoft Excel VBA Macros training exercises | Looping over collections

Showing exercises 1-7 (out of 7)

Category: Excel VBA Macros
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 ...

Category: Excel VBA Macros
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 ...

Category: Excel VBA Macros
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 ...

Category: Excel VBA Macros
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 ...

Category: Excel VBA Macros
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 ...

Category: Excel VBA Macros
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 ...

Category: Excel VBA Macros
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 ...

This page has 0 threads Add post