VBA – Beginner Level Training
Level
BeginnerDuration
16h / 2 daysDate
Individually arrangedPrice
Individually arrangedVBA – Beginner Level Training
Excel is commonly seen only as a spreadsheet, but it offers far more possibilities. With deeper skills, it can become a powerful tool for integration and data processing tasks. VBA programming unlocks even broader potential. This set of lessons and exercises will equip participants with the knowledge to program Excel for personalized and advanced goals.
What You Will Learn
- Understand and use object-oriented programming in VBA
- Create your own macros and functions
- Design user forms
- Program and trigger operations currently done manually
Who is this training for?
The course is intended for people familiar with Excel’s user interface who want to achieve more through task automation. Prior programming knowledge is helpful but not required.
Training Program
-
VBA Object Model
- Introduction to the object model
- Object-oriented thinking: properties and methods
- Objects and their types
- Excel user interface
- Data types
- Workbook, worksheet, and cell protection options
- Naming cells, ranges, and constants
-
Introduction to VBA Language
- VBA editor environment (Project Explorer, Properties, Code window, Immediate window, modules)
- Sub and Function procedures
- Objects, collections, hierarchy, and active objects
- Recording macros (relative and absolute reference mode)
- Editing and correcting recorded macro code
-
VBA Programming Basics
- Variables, data types, and constants
- Arrays and object variables
- Built-in functions
With ... End WithconstructFor Each ... NextconstructIf ... ThenconstructFor ... Nextloop
-
Creating Sub Procedures
- Declaring, creating, and executing
Subprocedures - Examples and use of selected commands
- Error capturing and handling
- Examples and exercises
-
Creating Function Procedures
- Declaring, creating, and executing
Functionprocedures - Example functions (with one, multiple, or no arguments)
- Detecting and resolving errors
- Examples and exercises
-
Using UserForms
InputBoxMsgBox- Controls
- Creating forms
- Events and forms
- Example forms
