Microsoft Office Excel 2013/2016 Programming with VBA

Home/Microsoft Office Excel 2013/2016 Programming with VBA
Microsoft Office Excel 2013/2016 Programming with VBA2020-09-11T10:05:29-04:00

Summary

  • Dates: Oct 28, 2020- Oct 29, 2020- Oct 30, 2020
  • Times: 9:00 am - 4:30 pm
  • Location: Virtual
  • Seats: 10
  • Price: $995

Outline

  • Getting Started

    • Introducing Visual Basic for Applications
    • Displaying the Developer Tab in the Ribbon
    • Recording a Macro
    • Saving a Macro-Enabled Workbook
    • Running a Macro
    • Editing a Macro in the Visual Basic Editor
    • Understanding the Development Environment
    • Using Visual Basic Help
    • Closing the Visual Basic Editor
    • Understanding Macro Security
  • Working with Procedures and Functions

    • Understanding Modules
    • Creating a Standard Module
    • Understanding Procedures
    • Creating a Sub Procedure
    • Calling Procedures
    • Using the Immediate Window to Call Procedures
    • Creating a Function Procedure
    • Naming Procedures
    • Working with the Code Editor
  • Understanding Objects

    • Understanding Objects
    • Navigating the Excel Object Hierarchy
    • Understanding Collections
    • Using the Object Browser
    • Working with Properties
    • Using the With Statement
    • Working with Methods
    • Creating an Event Procedure
  • Using Expressions, Variables, and Intrinsic Functions

    • Understanding Expressions and Statements
    • Declaring Variables
    • Understanding Data Types
    • Working with Variable Scope
    • Using Intrinsic Functions
    • Understanding Constants
    • Using Intrinsic Constants
    • Using Message Boxes
    • Using Input Boxes
    • Declaring and Using Object Variables
  • Controlling Program Execution

    • Understanding Control-of-Flow Structures
    • Working with Boolean Expressions
    • Using the If...End If Decision Structures
    • Using the Select Case...End Select Structure
    • Using the Do...Loop Structure
    • Using the For...To...Next Structure
    • Using the For Each...Next Structure
    • Guidelines for use of Control-of-Flow Structures
  • Working with Forms and Controls

    • Understanding UserForms
    • Using the Toolbox
    • Working with UserForm Properties, Events, and Methods
    • Understanding Controls
    • Setting Control Properties in the Properties Window
    • 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
    • Working with Control Appearance