0345 4506120

Microsoft Excel VBA Advanced

This intensive, hands-on one-day course has been designed to build on the foundation created in the VBA Introduction course, to increase their capability to automate and enhance their Excel spreadsheets by the use of advanced tools and concepts.

This course covers 2007, 2010, 2013 and 2016 versions

TARGET AUDIENCE

This is a course which naturally follows on from the Introduction course. Delegates must either have attended the Introduction course or be fully conversant with all its subject matter. Maximum class size for Microsoft Excel courses is 6 delegates, which ensures that attendees get adequate time for personal attention from the instructor.

ABOUT MICROSOFT VBA

VBA stands for Visual Basic for Applications and is a programming language developed by Microsoft. Although VBA is derived from the programming language Visual Basic, it is normally used within a host application (e.g. Excel, Access, etc.) not as a standalone language

Reset

Course Content

MODULE 1:  Advanced Procedures
Learning outcomes:
Explore the more advanced options of sub and function procedures to create more flexible programs
Topics covered:
  • Calling Procedures
  • Passing Values to Procedures
MODULE 2:  Advanced Variables
Learning outcomes:
Introduce advanced variable types to store data arrays and simplify the control of objects
Topics covered:
  • Understanding Variable Scope
  • Understanding Object Variables
  • Creating Array Variables
  • Creating Dynamic Array Variables
MODULE 3:  Interacting with Office Applications
Learning outcomes:
Gain an introduction into the use of VBA to control other office applications to create letters and presentations
Topics covered:
  • Setting References to other Applications
  • Setting References using Late Binding
  • Create a PowerPoint Presentation
  • Create a Letter in Word
MODULE 4:  Debugging and Error Traps
Learning outcomes:
Using VBA's debugging tools to find and correct errors in code, react to un-foreseen problems
Topics covered:
  • Review of Error Types
  • Debugging tools
  • Setting Error Traps
MODULE 5:  Creating Custom User Forms
Learning outcomes:
Use the VBA editor to create custom forms and controls, to gather and validate information from the user
Topics covered:
  • Creating a Custom Form
  • Adding Form Controls
  • Creating Event Procedures
MODULE 6:  Workbook and Worksheet Events
Learning outcomes:
Explore the use of Workbook and Worksheet events to react to the users actions and help control your application
Topics covered:
  • Create Workbook Events
  • Create WorkSheet Events

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Our Customers Include