Excel – Programming with VBA

Learning Method: Instructor-led Classroom Learning Duration: 3.00 Days


*Click here to view upcoming Excel Programming with VBA classes


Overview:

This course is for people who want to create and run macros, and use VB editor.  Students will also learn to use interface boxes, variable and conditional routines, add functionality and controls to forms, use PivotTables, and review debugging.

Course Outline:

Getting Started 

  • Introducing Visual Basic for Applications
  • Recording a Macro
  • Running a Macro
  • Understanding the VB Editor
  • Using the Menu Bar
  • Using the Standard Toolbar
  • Using the Project Explorer
  • Using the Properties Window
  • Understanding the Code Window
  • Understanding Code Window Options
  • Editing Code
  • Getting Help
  • Closing the Visual Basic Editor

Introducing Objects 

  • Understanding the Object Browser
  • Understanding Objects
  • Understanding the Object Hierarchy
  • Referencing Objects
  • Understanding Collections

Using the Editing Features 

  • Using the Immediate Window
  • Using the Auto List
  • Using Auto Quick Info

Introducing Variables 

  • Understanding Variables
  • Declaring Variables
  • Understanding Data Types
  • Storing Values in Variables
  • Storing Objects in Variables

Creating Procedures and Functions 

  • Understanding Procedures
  • Using the Macro Recorder to Create Sub Procedures
  • Calling Procedures from Procedures
  • Using Intrinsic Functions
  • Using Message Boxes
  • Using Input Boxes
  • Creating Functions
  • Passing Arguments to a Function

Working with Conditional Statements 

  • Understanding Conditional Statements
  • Working with Decision Structures
  • Working with Looping Structures

Working with Forms and Controls 

  • Understanding UserForms
  • Using the Toolbox
  • Working with UserForm Properties, Events, and Methods
  • Using the Properties Window
  • Understanding Controls
  • Working with the Label Control
  • Working with the Text Box Control
  • Working with the Command Button Control
  • Working with the Combo Box Control
  • Working with the Frame Control
  • Working with Option Button Controls

Adding Functionality to Forms 

  • Working with Control Appearance
  • Setting the Tab Order
  • Populating a Control
  • Adding Code to Controls
  • Launching Forms from Procedures

Using PivotTables 

  • Understanding PivotTables
  • Creating PivotTables
  • PivotTable Arguments
  • Adding Fields to PivotTables

Controlling Forms 

  • Controlling PivotTables from a Form
  • Controlling a Form from a Custom Toolbar

Understanding Debugging

  • Understanding Errors
  • Debugging Code
  • Debugging Tools
  • Using the Locals Window
  • Using the Watch Window
  • Using Breakpoints
Site Loader