image

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

Navigation

Select here if you are looking for another application

Select here if you are looking for another type of Excel Courses

Company customized courses

If you have up to 10 Colleagues for the same course, we have a special offer whether you provide a suitable training location or wants us to arrange it all. If needed we can also provide portable computers.

Price: 20.950,- DKK  excl. VAT

Look for more Courses with you and book an offer

Solo - Duo Course

If you prefer being on your own or perhaps with a Colleague, or if you have special wishes, then a solo/duo course might be the right choice for you.

Together we will design the content for your education.

Price: 7.950,- DKK excl. VAT per day.

Look for more information about Solo Courses and book an offer

Open Courses (open for all)

In the calendar to the right and below, you will find dates for open courses.

Please notice the different locations.

Pris: 6.500,-DKK. excl. VAT

Purpose of Excel VBA 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.

Duration

2 days at 09: 00-16: 00

Requirements

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.

Course content

 Macro recording

    • 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

        • Settings
        • Views
        • Creation of procedure and functions

          Using Dialogs

            • Input box
            • Message box
            • Design of data entry forms

              Data Types and Variables

                • Declaration of a variable
                • Constants
                • Standard variable naming conventions

                  Programming structures

                  • If-Then-Else
                  • Select Case
                  • Do-Loop
                  • Do-While
                  • For-Next

                  Excel Objects properties and metodes

                  • Application
                  • Workbook , ThisWorkbook, ActiveWorkbook ,
                    ActiveSheet, Worksheet
                  • Range
                  • Select
                  • Cells, Rows, Columns
                  • Address
                  • Offset

                  Events

                  • Workbook_Open/_Deactivate/_Activate
                  • Workbook_BeforeSave/_BeforeClose

                  Other topics

                    • Integration with other Office programs
                    • Error Handling

                      Additional courses

                      After this Excel VBA Basic course, we recommend the following course :
                      Excel VBA advanced course

                      Back to the overview of all Excel courses

                      Se mulighederne for et firma kursus

                      Referencer

                      "Kurset var rigtig godt tilrettelagt, og så var det en dygtig og kompetent underviser. -- Ole Christian Dalvang, Rambøll Management
                      SE ALLE REFERENCER