This training VBA macros will help candidates with all the essential skills required to handle the VBA environment, creating dashboards, using VBA macro applications and understanding other advanced topics associated to it. This course is structured and by the end of it, candidates will become aware of all necessary skills required to use macros in VBA.
Course Contents
Introduction
- Introduction to macros
- Introduction to Visual basic editor
- Modules
- Macros
Macro Code
- Macro architecture
- Running macros from VBA
- Utilities for running a macro
Visual Basic Editor
- Objects and methods
- Properties
- Programming tools
- Using the menu bar
VBA Syntax
- Objects
- Properties and methods
- Understanding parameters
- Object browser
- Object hierarchy
- Tools for coding
- Moving to other cells
- Editing specific cells
- Immediate Window
- Control through immediate window
- Formatting cells
- Using variables and constants
- Object variables
- Dimensioning
- Displaying data
- If and nested If statements
- Select case statements
Functions with VBA
- Functions and optional arguments
- Pass by value
- Pass by reference
- Creating custom functions
- Loops and their variation
- Do while and do until loops
- Using loops For loop
- Next loop
Variables
- Introduction to variables
- Creating variables
- Setting variables
- Explicit variables
- Implicit variables
Advanced Techniques
- Excel utilities with VBA
- Error Handling
- Using built-in excel features
- Pivot tables and charts
- Importance of excel events
- Interaction with other applications
- Add Ins
App development
- Working with Ribbon and shortcut menus
- Support for applications
- Development of user oriented apps
Connecting to Database and Outlook
- Connecting to MS access and outlook using VBA
- Retrieve data from MS access
- Modifying DB
- Filter DB using Query
- Query data grouping, retrieve mail and CC address
- Retrieve mail subject and attachment
