WISE OWL EXERCISES
VBA EXERCISES
EXCEL VBA MACROS EXERCISES
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. |
| 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. |
| 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. |
| 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). |
| 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. |
| 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. |
| 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. |
| 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. |
| 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!. |
| 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. |
| 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. |
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