Excel VBA Macros | Visual Basic explained exercise | Recognising Collections, Objects, Methods and Properties

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 course listed below!

Software ==> Excel VBA Macros  (52 exercises)
Version ==> Any version of Excel
Topic ==> Visual Basic explained  (3 exercises)
Level ==> Average difficulty
Course ==> Excel VBA macros

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.

Consider the screen shot below:

Screen shot of model

An excerpt from an Excel financial model.

Name 4 collections that you can see in this screen shot, and estimate the number of objects that each contains.

Write down the VBA commands to do the following, parsing each to show the objects, collections, methods and properties that you've used:

  1. Select the range called CostLabour.
  2. Display the row number of the active cell in a message box.
  3. Go to the Calculations worksheet.
  4. Close the current workbook.

Finally, see if you can describe the last holiday you went on to your slightly odd friend who only speaks VBA (for the purposes of this exercise you can assume that the collections, objects, methods and properties that you refer to exist within the Excel object model).

This page has 0 threads Add post