Microsoft Excel VBA Advanced Training course Outline

Audience: This course is aimed at experienced Excel VBA users who need to move to the next level. Create User Forms, create Add-ins and automate the other Office applications.

Course Duration: 1 day

Course Availability: Monday – Saturday

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.

Course Location: This Microsoft Excel VBA advanced training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

At Course Completion

After completing this course, students will be able to:

  • Appreciate the Excel Object Model
  • Store data in Arrays
  • Use Triggers and Events
  • Pass and Type argument values
  • Work with Text Files
  • Create User Forms
  • Automate other Office applications
  • Create Excel Add-Ins

Course Outline

Module 1: The Excel Object Model

  • Exploring the Range object in detail
  • CurrentRegion and UsedRange properties
  • Working with collections of Workbooks and Worksheets
  • Manipulating Charts and PivotTables

Module 2: Arrays

  • Efficient variable storage with arrays
  • Dynamic arrays
  • •he Array function

Module 3: Triggers and Events

  • Running macros automatically
  • Executing macros on a timer
  • Associating macros with Workbook events

Module 4: Parameters

  • Passing data By Reference and By Value

Module 5: Working with Text Files

  • Importing text files
  • Exporting text files

Module 6: User Forms

  • Controls Toolbox
  • Using User Form properties, events and methods
  • Understanding controls
  • Label controls
  • Text box controls
  • Command button controls
  • Combo box controls
  • Option button controls
  • Determining the tab order
  • How to launch a form in code

Module 7: Office Automation

  • Connecting with other MS Office applications
  • Manipulating Access data using DAO, ADO and ADODB
  • Understanding ActiveX data objects
  • Using Excel to communicate with other data sources
  • Understanding the connection string
  • Adding, reading, modifying and deleting data

Module 8: Add-Ins

  • How macro security works
  • Password protecting your code
  • Creating Add-Ins
, Microsoft Excel VBA Advanced Training course
, Microsoft Excel VBA Advanced Training course