Exercise 3.02

The aim of this exercise is to loop over a list of films and use conditional functions to calculate values for each row.

Files Needed

Click here to download the file needed for this exercise.

Instructions

1. Extract and open the Movies.xlsm workbook to find a worksheet containing a list of films:

The first three films in the list are shown here.

2. Create a subroutine which begins by selecting cell A2.
3. Add a conditional loop to the subroutine which selects the cell below the active cell and continues doing so until a blank cell is selected.
4. Within the loop, use an IIf function to assign a value to the Success column (column D) based on the number of Oscars a film has won:

5. Within the loop, use a Switch function to assign a value to the Length column (column F) based on the Run Time of a film:

6. Run the subroutine you have written and check that you see the expected results:

A selection of results from the list.

7. Save and close the workbook.

Answer Files

Click here to download a file containing a suggested answer.