VBA for Microsoft Excel
This course will teach programming concepts and how to add functionality to a Microsoft Excel using Microsoft Visual Basic® for Applications.
At Course Completion

At the end of the course, participants will be able to:

  • Use the programming capabilities of Microsoft Visual Basic for Applications in Microsoft Excel applications to write custom functions and event-driven procedures.
  • Validate data
  • Find and trap errors
  • Create a custom function for a Microsoft Excel application.
Prerequisites

Before beginning this course, participants should be able to:

  • Extensive understanding of Microsoft Excel or previous version of Microsoft Excel
  • Basic programming knowledge in Visual Basic

Why you should train with us?

Quality Assured

Generate New Idea

Telephone Support

Certified Instructor

Improve Productivity

SMS Support

Practical Example

Updated Resources

Email Support

Course Outline

Duration: 2 days

Module 1: Make a Macro Do Simple Tasks

  • What’s the Difference between VBA and a Macro
  • Creating a Simple Macro
  • Changing Multiple Properties at Once
  • Manipulating Recorded Properties
  • Recording Methods in a Macro

Module 2: Make a Macro Do Complex Tasks

  • Task One: Opening the Report file
  • Task Two: Filling in Missing Labels
  • Task Three: Adding a Column of Dates

Module 3: Explore Workbooks and Worksheets

  • What is an object?
  • Understanding Workbooks
  • Understanding Worksheets

Module 4: Explore Range Object

  • Referring to a Range
  • Enhancing Recorded Selections
  • Entering Values and Formulas into a Range
  • Formatting a Range

Module 5: Explore Data Objects

  • Working with Excel Tables
  • Working with PivotTable Reports

Module 6: Explore Graphical Objects

  • Exploring Graphical Objects
  • Exploring Charts Objects

Module 7: Control Visual Basic

  • Using Conditionals
  • Creating Loops

Module 8: Extend Excel and Visual Basic

  • Creating Custom Functions
  • Handling Errors

Module 9: Launch Macros with Events

  • Creating Custom Command Buttons
  • Handling Worksheet and Workbook Events

Download PDF Version Here

Interested to know more about this course? Reach out to us now!

2 + 7 =