Microsoft Excel Macro/VBA (Part1) Duration: 1 Day
Course Overview
This course introduces users to the process of writing and editing Macros. No prior programming experience is assumed. Candidates should have an excellent working Knowledge of Excel or should have attended the Excel L3 training. FURTHER TRAINING: MS Excel MACRO PART 2 1 day course is available which builds on this training (Part1) The course can be run as a 2 day course or as separate 1 day courses.
This course introduces users to the process of writing and editing Macros. No prior
programming experience is assumed. Candidates should have an excellent working
Knowledge of Excel or should have attended the Excel L3 training.
FURTHER TRAINING: MS Excel MACRO PART 2
1 day course is available which builds on this training (Part1)
The course can be run as a 2 day course or as separate 1 day courses.
Introducing Visual Basic for Applications
- Configuring Excel’s security and trust settings.
- Recording a Macro
- Absolute vs. relative recording modes
- Running a Macro
- Automatically executing macros
- Editing a Macro in the Visual Basic Editor
- Understanding the Development Environment
- Using Visual Basic Help
Working with Procedures and Functions
- Understanding Modules
- Creating a Standard Module
- Understanding Procedures
- Creating a Sub Procedure
- Calling 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...Next Structure
- Using the For Each...Next Structure
- Guidelines for use of Control-of-Flow Structures
Creating Excel Addins
- Writing Excel addins
- Loading addins
Microsoft Excel Macro/VBA (Part1) Duration: 1 Day
Course Overview
This course introduces users to the process of writing and editing Macros. No prior programming experience is assumed. Candidates should have an excellent working Knowledge of Excel or should have attended the Excel L3 training. FURTHER TRAINING: MS Excel MACRO PART 2 1 day course is available which builds on this training (Part1) The course can be run as a 2 day course or as separate 1 day courses.
This course introduces users to the process of writing and editing Macros. No prior
programming experience is assumed. Candidates should have an excellent working
Knowledge of Excel or should have attended the Excel L3 training.
FURTHER TRAINING: MS Excel MACRO PART 2
1 day course is available which builds on this training (Part1)
The course can be run as a 2 day course or as separate 1 day courses.
Introducing Visual Basic for Applications
- Configuring Excel’s security and trust settings.
- Recording a Macro
- Absolute vs. relative recording modes
- Running a Macro
- Automatically executing macros
- Editing a Macro in the Visual Basic Editor
- Understanding the Development Environment
- Using Visual Basic Help
Working with Procedures and Functions
- Understanding Modules
- Creating a Standard Module
- Understanding Procedures
- Creating a Sub Procedure
- Calling 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...Next Structure
- Using the For Each...Next Structure
- Guidelines for use of Control-of-Flow Structures
Creating Excel Addins
- Writing Excel addins
- Loading addins
