Description
Save time with our ‘Excel: VBA Programming’ training
Excel is a powerful application. Have you encountered situations where you had to insert the same data or execute the same actions over and over? If so, you’ll be thrilled to hear that you can avoid these time-consuming repetitions.
Create a user-friendly form? Set up the same filter for countless sheets? Generate workbooks and/or worksheets automatically? You’ll learn it all in our ‘Excel: VBA Programming’ training.
In this (technical) training, you’ll learn how to automate your work in Excel using Office’s programming language (Visual Basic for Applications). You’ll never have to waste time on repetitive actions again and you’ll be able to spend more time on other tasks. Can you be any more productive?
Objectives
After this training, you’ll be able to develop your own applications in Excel Visual Basic for Applications (VBA).
Target Group
Everyone who carries out the same action in Excel regularly and would benefit from automating it.
Prerequisites
You don’t need any experience with VBA, but decent Excel knowledge is required. This means you need to be familiar with the following terms: PivotTables, conditional formatting, data validation, tables, charts, slicers, etc. Good analytical insight is a plus as well.
Content
Part 1: Macros
- Saving a macro
- Linking a macro to a button
- Understanding macro limitations
Part 2: Basic Principles of VBA and Programming
- Visual Basic Editor (Project, Code, and Properties windows)
- Modules
- Variables (declaration, scope, data types)
- Routines (subs vs. functions; writing custom functions)
- Decision structures (If…Then…Else, Select Case)
- Loops (For…Next, Do While, Do Until, etc.)
- Message boxes for user interaction
- Error handling
Part 3: Using Excel Objects in Your Code
- What is an object?
- Object properties, methods, and events
- Application object (modifying Excel settings via code)
- Workbook object (open, create, save, close workbooks)
- Worksheet object (add, delete, copy sheets)
- Range object (copy cells, read/write data, delete content)
- ListObjects (create and loop through tables)
- Other objects (PivotTables, Charts, etc.)
Part 4: Developing Forms
- Working with form controls (buttons, list boxes, checkboxes, etc.)
- Creating custom forms (adding controls and programming them)
