We also offer courses and publications in: UK Flag London US Flag New York
  • Join us for the latest updates, tips and course dates!

Excel - Module 4: VBA 2: Woring wth Objects, Properties and Methods

Excel gives you the edge whenever you want to do something new with financial models, something never seen before in instrument pricing, and something that none of your competitors has ever done.
Delivered via Virtual Classroom you will be able to engage with the instructor and other participants, share screens, ask questions without leaving your office or your home, city or country.

Description

VBA is based upon object hierarchies, with each object possessing various properties and methods. This module explores this basic structure of VBA and how it is exploited to create new tools for Excel users. 

• VBA object hierarchy
• Application, ActiveWorkbook, and ActiveSheet
• Objects
• Properties
• Methods
• Defining variables
• Populating variables