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
- What can a macro not do?
Part 2 Basic principles of VBA and Programming
- Visual Basic Editor (Project window, Code window, Properties window)
- What are modules?
- Variables (Declaration, Scope, Data types)
- Routines (Difference between sub and function; Writing your own functions)
- Decision structures (If then else; Select case)
- Loops (for next, do loop while, do loop until, do while loop, do until loop)
- Showing message boxes to the end user
- Error handling
Part 3 Using Excel objects in your code
- What is an object?
- Properties, methods (actions), and events of an object
- Application (Changing Excel application properties via code)
- Workbook(s) (Opening/creating/saving/closing workbooks via code)
- Worksheet(s) (Add, delete, copy worksheets… via code)
- Range (Copying cells, reading data from Excel, deleting data…)
- Listobjects (Creating tables, going through the rows/columns of tables…)
- Miscellaneous (PivotTables, Charts…)
Part 4 Developing Forms
- Working with Form Objects ((Buttons, List Boxes, Check Marks…)
- Creating your own form (accessing a form, placing objects on a form (textbox, combobox, buttons….) and programming them)
