Microsoft Excel 2007
Visual Basic explained exercise
Average difficulty

This Microsoft Excel 2007 VISUAL BASIC EXPLAINED exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl EXCEL 2007 VISUAL BASIC course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Exercise: Speaking Visual Basic

1) Download the files needed to start this exercise: exercise-908.zip (and click here if you experience any problems unzipping this file after downloading it).
2) In the remote republic of Nerdania, all of the natives have evolved to speak only in Visual Basic for Applications (it is not a place you would visit on holiday).  See if you can translate the following sentences from NerdSpeak into English:
Exercise screen-shot 2010 For each sentence, you have to identify the method or property
3) You are planning a business trip to Nerdania.  See how many of the following statements you can translate into Nerdanian:
  • Stop the Microsoft paper-clip assistant appearing on screen
  • Catch the pigeon
  • Turn the TV off
  • Eat the second biscuit in your packet of Hob Nobs
  • Hide the first worksheet
4) Finally, some special cases:
  • Buy a tall skinny latte with an extra shot
  • Change your name by deed poll to Susan

Thank you for showing an interest in this Excel 2007 Visual Basic training course!

All content � Wise Owl Business Solutions Ltd 2007.  All rights reserved.  Design by Branches.