wordpress.simplitrain.com

course

Home / Courses / Excel 2013/2016 Programming with VBA

Agenda

  • 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
  • Setting the Tab Order
  • Populating a Control
  • Adding Code to Controls
  • Launching a Form in Code

  • Understanding PivotTables
  • Creating a PivotTable Using Worksheet Data
  • Working with the PivotTable Objects
  • Working with the PivotFields Collection
  • Assigning a Macro to the Quick Access Toolbar

  • Understanding Errors
  • Using Debugging Tools
  • Setting Breakpoints
  • Stepping through Code
  • Using Break Mode during Run mode
  • Determining the Value of Expressions

  • Understanding Error Handling
  • Understanding VBA’s Error Trapping Options
  • Trapping Errors with the On Error Statement
  • Understanding the Err Object
  • Writing an Error-Handling Routine
  • Working with Inline Error Handling

  • 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

  • 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
  • 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

  • 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

  • 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
Tags
Vendor: Logical Operations Applications Core Type: Core 4 Product Line: Microsoft Applications LoD Tier: 1
FREE

Interested in course?

Buy Course

Course Type: Instructor Led