Visual Basic for Excel Advanced

Duration 2 Days

Who Should Attend:

Anyone wishing to take their VBA knowledge beyond that of the basic course. Basic VBA knowledge is assumed.

Learning Outcomes:

  • Construct of an application
  • Create Add-ins
  • Understand Class modules
  • Combine external applications and files
  • Programmatically create Charts
  • Create Pivot tables in VBA

Course Content:

  • Review of user forms
  • Workbook and Worksheet events
  • Application of dynamically populated List items
  • Use of form templates to dynamically manipulate form display contents at runtime
  • Assigning macros to ribbon tabs (toolbars)
  • Creation and maintenance of menus
  • Creation of add-in workbook
  • Application of ribbon tab to invoke and control an add-in
  • Application of Excel options window to activate an add-in
  • Overview of class module versus program module
  • Creation of property and method procedures  in classes
  • Use and manipulation of class modules
  • Use of data from other Excel files
  • Use of object hierarchies in other Microsoft Office applications
  • Data storage in the Windows registry
  • Creation of Charts in VBA
  • Creation and manipulation of Pivot tables