Introduction to Excel VBA

Tailor-made training

Would you rather have a tailor-made training based on this course? Contact us and we will make it work.
 
 

Description

The following is a standard lesson content as an example. It is highly recommended to carry out a good target group/needs analysis before proposing a real lesson content.

An advanced course is also possible – it is recommended to make this a workshop in which the participants bring their projects (and send them in advance).

Contents

Macros

  • Recording a macro
  • Attaching a macro to a button

Visual Basic

  • The VBE (Visual Basic Editor)
  • Modules
  • Variables
  • Procedures and functions
  • Inputbox and Msgbox
  • Decision-making structures
  • Loops
  • Error Handling

Excel Objects

  • The Excel Object Model
  • Properties, Methods, and Events
  • The application object
  • The workbook(s) object
  • The worksheet(s) object
  • The range object

Forms

  • Working with form objects (buttons, drop-down list, checkbox, etc.)
  • Working with forms in Excel

Target audience

Anyone who regularly carries out the same actions in Excel and would like to know how to automate these actions.

Prerequisites

Good knowledge of Excel (Knowledge of Visual Basic is not required).

Duration

3 days
Tailor-made training
Each organization is unique in its identity, and no co-worker is the same. That's why we at Learnia offer our clients tailor-made courses as well.
Continue reading