EXERCISE TOPIC▼
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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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