Excel VBA Course

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.

company course

20.950 DKK excl. VAT
  • Up to 10 participants

Solo course

7.950 DKK excl. VAT
  • For 1 or 2 participants

open courses

6.500 DKK excl. VAT
  • 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.

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
 

Back to the overview: Excel courses. Se også: Excel VBA kursus på dansk

No event found!
Hent flere

This course includes