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
