Details
Goals
Being able to program with Visual Basic (VBA) in Excel.
Prerequisite
Good Windows and Excel skills.
Contents
Interface
Terminology
- Key Words
- Description of an object in VBA
Recording
- Recording procedure
- Recording options
- Manual execution of a macro
Creating a procedure –Subroutine
- Inserting new modules
- Inserting a new procedure or function
- Help in the creation process
The variables
- Variables accessibility
- The “Dim as” statement
References and Selections
- Cell references
- Object references
- Selection of a cell or of an object
Interactivity
- Inputbox
- Msgbox
Conditions
- The “IF” Statement
- The “Select Case” Statement
Loops
- For…Next
- Do…Loop
Object manipulations
User Forms
Debugger
- Step by step execution
- Break point
- Watch-Immediate window
Functions
Managing errors codes
Sign up
Next session(s)
Need a custom training?
None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!