The Example Workbook

Extract and open the file linked to in the Files Needed section above.  You'll find a worksheet which contains a very simple game based on generating random numbers:

You can click the button in cell C2 to create a new set of random numbers.

Clicking the button in cell C2 runs a subroutine which creates a new set of random numbers:

You can find the subroutine in the VBE.

If we assume that the player with the highest number is the winner, we'd like to add some code which will indicate who has won and lost:

We'll use different colours and text to indicate the winner and loser.

Creating a Basic If Statement

To begin, we'll add some code which changes the fill colour of the two cells if player 1 is the winner.  Add an If statement below the existing code in the Roll_Again subroutine:

Test if the value of cell B2 is greater than that of cell D2. You can use the > operator to do this.

Add instructions to change the fill colour of the two cells, as shown below:

Here we're using green for the winner and red for the loser. Feel free to use any combination of colours you prefer.

Add the End If statement:

As this is a block If statement we'll need an End If statement.

In Excel, try clicking the Play! button until cell B2 contains a larger number than D2:

When player 1 wins, the cells will change colour.

Unfortunately for player 2 at this stage, there is no way for them to win:

When cell B2 doesn't contain a higher number than D2, the cells remain grey in colour.

Adding the Else Clause

To allow player 2 to win, add an Else clause to the If statement:

The Else keyword should occupy its own, separate line of code between the If and End If statements. Conventionally, it should be placed at the same indent level as the If statement.

You can now add instructions below the Else clause:

These instructions will flip the red and green colours when player 2 wins.

Return to Excel and try playing the game again:

This time, player 2 can win!

Now that you've seen the basic concept of the Else clause you can either complete the Extra Practice section below, or move on to the next part of the lesson to learn about the ElseIf statement.

To practise using the Else clause:

1. In the same subroutine, add instructions to the If statement to write the words Winner and Loser into the worksheet when player 1 wins:

2. Add two instructions below the Else clause to indicate when player 2 is the winner:

3. Click the button on the worksheet to check that the correct word appears when each player wins:

The appropriate text will appear below each player's number.

4. Add two instructions below the If statement to change the colour of the font when player 1 is the winner:

5. Add two instructions below the Else clause to change the colours when player 2 is the winner:

6. Click the button on the worksheet and check that you see the appropriate word in the appropriate colour below each player's number:

Everything should now work as expected.

7. Save and close the workbook.