You will learn
On this Excel VBA Programming Basic course, you will learn the fundamental principles of programming with Visual Basic for Applications (VBA) in Excel.
The course is designed for experienced Excel users who want to take the next step and learn how to automate tasks using VBA. You will learn how to write your own code and work with variables, control structures, loops, Excel objects, UserForms and functions.
The course runs over three days, giving you plenty of time to work with practical exercises and become more confident writing and working with VBA code.
After the course, you will be able to:
- Work with variables, constants and data types to handle values in your code.
- Use IF structures and loops to control when and how many times code is executed.
- Access rows in larger ranges and process values in specific columns.
- Write code that works with worksheets and workbooks, for example to control sheet or file names.
- Work with cells using VBA, including selecting cells, assigning and retrieving values and copying or moving cells.
- Build UserForms with options that your code can respond to.
- Create your own functions so that useful code can be reused.
You can find a complete overview of the topics covered under Course Details further down the page.
See also our full selection of Excel courses.
You get
Before the course
- The opportunity to speak with an instructor who can help you determine whether this is the right course for you.
During the course
- Training by an experienced instructor team with many years of experience in Excel.
- Practical training that combines theory with hands-on exercises.
- Course material that you can use as a reference after the course, as well as course exercises.
- Training in our classrooms in central Copenhagen.
- Full catering including breakfast, freshly brewed coffee, tea, fruit, soft drinks, lunch at a nearby restaurant, cake and sweets.
- A course certificate documenting your participation and new skills.
After the course
- Access to our free hotline for up to one year, where you can contact us with questions about the topics covered during the course.
- Our satisfaction guarantee, giving you extra reassurance that you will get the full benefit of your course.
Get the best benefit from the course
This Excel VBA Programming Basic course is designed for experienced Excel users who want to learn the fundamentals of VBA programming and use code to automate tasks in Excel.
We recommend that you have completed our Excel Experienced course or have equivalent knowledge of the topics covered on that course.
No previous programming experience is required.
The course is taught in English and is part of our selection of English conducted courses.
Course Details
Module 1: Recording macros
In this module, you will learn the basics of recording macros. You will look at what to consider before recording a macro and when recorded macros can be useful.
The following topics will be covered:
- Relative/absolute recording
- Where do you save macros?
Module 2: Introduction to ribbon, toolbars and icons
In this module, you will learn how to create shortcuts that give you easy access to your macros.
The following topics will be covered:
- Creating macro shortcuts
Module 3: The Visual Basic Editor
In this module, you will learn how to create Subs and adjust settings in the VBA Editor. You will also work with IntelliSense when entering code for different objects.
The following topics will be covered:
- Creating Subs
- Options for the Editor
- Using IntelliSense
Module 4: Variables and data types
In this module, you will learn how to declare variables using different data types. You will also work with where variables can be accessed from and the lifetime of a variable.
The following topics will be covered:
- Declaring variables
- Local variables - module variables - global variables
- Constants
- Object variables - converting variables
- Naming conventions
Module 5: Simple dialogues
In this module, you will work with common dialogues that can be used to communicate with the user. This can range from displaying a simple message to receiving input from the user.
The following topics will be covered:
- The MsgBox command
- The InputBox function
- MsgBox functions
Module 6: Control structures
In this module, you will learn about conditional structures, which allow your code to respond differently depending on the values being tested.
You will also work with loops, which can be used when the same lines of code need to be executed repeatedly, for example across multiple rows, cells or worksheets.
The following topics will be covered:
- Statements (If-Then-Else and Select Case)
- Loops (Do-Loop, Do-While and For-Next)
Module 7: Splitting codes into sub-routines
In this module, you will work with ways to reuse your VBA code. By placing code in a Sub, the same code can be called multiple times.
You will also work with passing arguments to a Sub, allowing the procedure to use different values when it is called.
The following topics will be covered:
- Calling a Sub from another subroutine
- Calling a Sub from another subroutine with arguments
Module 8: Formulas
In this module, you will work with some of the most commonly used controls in a UserForm. You will learn about the purpose of UserForms and how events can be used with controls and UserForms.
The following topics will be covered:
- Designing your own dialogues with labels, text boxes, combo boxes, check boxes, etc.
- Scope of application
- Using events
Module 9: The most essential excel objects
In this module, you will work with some of the most commonly used objects in Excel. You will learn how to work with these objects and their methods and properties in VBA.
The following topics will be covered:
- Application
- Workbook, ActiveWorkbook, ThisWorkbook
- Worksheet, ActiveSheet
- Range - Select - Address
- Offset
- Cells, Rows, Columns
Module 10: Events for the Excel File
In this module, you will work with automatic events that occur when you perform different actions in Excel, for example when opening or closing a workbook, activating a worksheet or changing a cell value.
The following topics will be covered:
- Workbook Open - Workbook Deactivate - Workbook Activate - Worksheet Activate
Module 11: Functions
In this module, you will learn how to create your own functions. Excel contains many built-in functions, but VBA also allows you to create your own functions and use them in worksheets or within the VBA environment.
The following topics will be covered:
- Declaring functions
- Applying functions in the Excel worksheet
Module 12: Arrays
In this module, you will be introduced to multidimensional variables, also known as Arrays. You will learn what an Array is and why this type of structure can be useful in VBA.
The following topics will be covered:
- Declaring Arrays
- How to ReDim an Array
- Using Arrays
Module 13: Simple Error Management
In this module, you will learn about errors that can cause your VBA code to stop running. The focus is on preventing the end user from ending up in the Visual Basic environment with an unexpected error message.
The following topics will be covered:
- The Error object
Vælg dato, by og deltagere
Længde
3 dage
Pris
13,500 kr.
ex moms
Sted
System.Collections.Generic.List`1[System.String]
02-12-2026
03-12-2026
Kl: 09:00-16:00
Kl: 09:00-16:00
Hvad siger vores kunder om os?
Siden 1991 har 4D Academy hjulpet virksomheder og specialister med at omsætte viden til målbare resultater. Vores kursister belønner os med en gennemsnitlig rating på 4,8 ud af 5 på Trustpilot, Google og Facebook, og det gør os stolte.
Se hvorfor både nye og erfarne fagfolk vælger os, når de vil løfte deres kompetencer.
Hold dig opdateret med vores nyhedsbrev
Her bor vi
Læderstræde 22, 2. sal, 1201 København K
Tueager 5, 8200 Aarhus
Ørbækvej 350, 5220 Odense
Tirsdag: 08.00 - 16.00
Onsdag: 08.00 - 16.00
Torsdag: 08.00 - 16.00
Fredag: 08.00 - 16.00
