- Description
- Reviews
Duration: 2 Days Training / Virtual Instructor-Led
COURSE DESCRIPTION
Visual Basic Analysis (VBA) is a human-readable and editable programming code that gets generated when you record a macro. The VBA Advance Training Program covers the more advanced functions and more powerful features of VBA, thereby expanding the possibilities of what the Learners can make out of the VBA Application.
COURSE OBJECTIVES
Upon completion of the training, learners should be able to
-
Modify a variety of standard behaviors, such as double clicking, opening files and saving files.
-
Learn external libraries, and how you can extend VBA’s capabilities beyond standard Excel options.
-
Modify the Excel user interface, including the “Ribbon” and context menus to interact with your VBA code
-
Be able to create a simple VBA Project applying the Learnings from the Training
PREREQUISITES
Attendees of this training are expected to have completed the VBA Fundamentals Training.
INTENDED AUDIENCE
-
Those who have completed their VBA Fundamentals Training and intend to move up further in terms of their knowledge in VBA and apply more advanced VBA functions
-
Attendees of this Training come from a myriad of vocation – sales, marketing, HR personnel, managers, accountants, bookkeepers, educators, among others
COURSE OUTLINE
Module 1: Setting Up VBA Excel Interface
-
Enable Developer Tab
-
Saving And Setting Macro Enabled Files
-
Creating Name Managers for Data Management
-
Configuring Name Manager
-
Applying Basic Macro Programming with Excel Formulas
Module 2: Variables and Data Types
- Variables
- Introduction To Data Types
- Integral Numeric Variables
- Decimal Variables
-
Introduction To Strings
-
Fundamentals Of Dates
-
Any-Type Variables
-
The Scope or Lifetime of a Variable
-
The Access Level of a Global Variable
Module 3: Create Programs with User Intervention
- Creating Modules
- Call Procedure Inside the Modules
- Message Box and Inputbox Settings
-
Module 4: VBA Operators and Operands
- VBA Operators
- Arithmetic Operators
- Logical Operators
Module 5: Conditional and Iteration Programming
- Conditional Statements and Functions
- If-Condition Built-In Functions
- The Select…Case Statement
- Loop Repeaters
- Loop Counters
- Exiting A Procedure or A Loop
Module 6: Introduction to Excel VBA User Forms
- Forms Fundamentals
- Using A Form
- The Characteristics Of A Form
- Controls Fundamentals
Module 7: Error Handling and Debugging
- Handling Errors
- In Case of Error
- Types of Error
- The Err Object
Module 8: VBA Functions
-
Create Function Names
-
Declare Variables in Functions
-
Call and Run VBA Functions
-
Create Pivot Table and Chart Commands with Excel Functions
Final Project: Creating A VBA Project with the ff. Criteria
-
Excel Data Source
-
Variables And Data Types
-
Sequential Programming (Basic Functions)
-
Selection Programming
-
Iteration Programming
-
User Form to Excel Transaction Includes (Add, Edit, And Delete)
-
Error Trapping