In this Excel VBA Basic Course, you will learn how to automate your workflow in Excel using Visual Basic for Application.
To the right and below you can see where and when the next courses in Excel VBA are offered. We also offer company customized courses.
Up to 10 participants
For 1 or 2 participants
Attend an open course
Excel VBA Basic course
This Excel VBA course teaches you ti automate your work with Excel bulit-in programming tool called Visual Basic for Application.You will learn to create macros in Excel and it give you a good basic understanding af VBA programming language.
You will learn to automate different routines with VBA using Excel objects, how to handle basic user input/output and how to use the built-in programming structures such as loops and conditions.
The overall objective of this course is for you to be able to create simple tools in order to save time when dealing with repetitive tasks in Excel.
2 days at 09: 00-16: 00
To take full advantage of the course, we recommend that you are an experienced user of Excel or have a knowledge corresponding our advanced course.
You can attend this course regardless of the Excel version you are using.
- Where are macros stored
- Relative and absolute recorded macros
- Shortcuts and buttons for macros
- Using the Visual Basic Editor to modify macros
Intro to Visual Basic Editor
- Creation of procedure and functions
- Input box
- Message box
- Design of data entry forms
Data Types and Variables
- Declaration of a variable
- Standard variable naming conventions
- Select Case
Excel Objects properties and metodes
- Workbook , ThisWorkbook, ActiveWorkbook ,
- Cells, Rows, Columns
- Integration with other Office programs
- Error Handling