Exercise: Maze -Recording

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

The answer to the exercise will be included and explained if you attend the Wise Owl course listed below!

Category ==> Excel VBA Macros  (38 exercises)
Topic ==> Recording macros and buttons  (7 exercises)
Level ==> Relatively easy
Course ==> Excel VBA macros
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Open the file found in the folder above.

Record 4 macros to work as follows:

  • A new macro called Down, such that when you press CTRL + SHIFT + D the macro takes you down one cell.
  • A new macro called Up, such that when you press CTRL + SHIFT + U the macro takes you up one cell.
  • A new macro called Left, such that when you press CTRL + SHIFT + L the macro takes you left one cell.
  • A new macro called Right, such that when you press CTRL + SHIFT + R the macro takes you right one cell.

Test your macros out by starting in cell B2 and pressing the appropriate sequence of keys:

Excel VBA Macros exercise - Recording macros and buttons (image 1)

The first sequence of keys is:CTRL + SHIFT + D

Now record a fifth macro called Cheat, which takes you straight to the cell containing the gold, regardless of your current starting position.

Think carefully about whether you should be recording in relative or absolute mode.

Add some buttons to your workbook to make these macros easier to run:

Excel VBA Macros exercise - Recording macros and buttons (image 2)

The buttons do not have to be perfectly aligned.

Save your amended workbook as Maze with Macros & close it down.

This page has 0 threads Add post