Description

Understand the object hierarchy in Excel. The course introduces object properties, or characteristics, and methods, or actions, and how these can be manipulated using Excel VBA. Follow practical demonstration of writing Excel VBA procedures to change and perform functions on data in a spreadsheet.

Learning Objectives

---

1. Identify the hierarchy of objects in Excel VBA, including the application, workbooks, worksheets, and range objects.
2. Recognize the difference between properties and methods of an object in Excel VBA.
3. Apply VBA code to manipulate the value property of a range object.
4. Use the Object Browser to explore the properties and methods of objects in Excel VBA.
5. Evaluate the effectiveness of VBA code in performing specific tasks, such as copying a range of cells.