Excel VBA Macros exercises on LOOPS AND CONDITIONS

This page lists the 5 exercises about Loops and conditions in Excel VBA Macros on our website:

Software: Excel VBA Macros
Version: Any version of Excel
Topic: Loops and conditions
Level: Relatively easy
Course: Excel VBA macros
Exercise: Write a macro to loop over cells following instructions until you reach the cottage of Red Riding Hood!.

Go to exercise ...

Software: Excel VBA Macros
Version: Any version of Excel
Topic: Loops and conditions
Level: Average difficulty
Course: Excel VBA macros
Exercise: Write a macro to loop over a column of dinosaurs, colouring the ones meeting certain conditions.

Go to exercise ...

Software: Excel VBA Macros
Version: Any version of Excel
Topic: Loops and conditions
Level: Average difficulty
Course: Excel VBA macros
Exercise: Use a Do Until loop to extract invalid data from a list of dating-agency applications in Excel VBA.

Go to exercise ...

Software: Excel VBA Macros
Version: Any version of Excel
Topic: Loops and conditions
Level: Average difficulty
Course: Excel VBA macros
Exercise: Loop over rows of data (rollercoasters) building up message displaying only wooden ones.

Go to exercise ...

Software: Excel VBA Macros
Version: Any version of Excel
Topic: Loops and conditions
Level: Average difficulty
Course: Excel VBA macros
Exercise: Use If statements in Excel VBA to validate a set of user inputs in a Dating Agency workbook.

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