Lifelong learning for working professionals
VBA programming

VBA programming

Course Summary

This course is for those who want to learn how to connect different programs to work more efficiently using Visual Basic for Applications, VBA.
We show you how to make the programs in MS Office work together and how to retrieve and use information from external data sources.
Developing applications for MS Office often means great time savings and reduced risk of errors as routine tasks are automated.
Examples in the course are based on Excel.

Programming experience and extensive experience working in MS Office, mainly Word and Excel.

1. introduction

  • Different types of macro
  • Areas of use

2. Introduction to VBA

  • Record and run VBA macros with the recorder
  • Viewing and editing VBA macros
  • Visual Basic Editor

3. usability

  • Linking code to buttons and menus
  • Link code to events; select, deselect, click, etc.
  • Create your own and customize menus

4. dialog boxes

  • Create dialog boxes
  • The toolbox
  • Events

5. Variables and constants

  • Different variables
  • Data types
  • Enter constants
  • Get the host
  • MsgBox
  • InputBox

6. procedures and functions

  • Create and use procedures/functions
  • Modules
  • Create procedures Sub
  • Create functions Function

7. several ways to control VBA code

  • Select-Case
  • For-Next
  • For-Each-Next

8. Object orientation

  • What is an object?
  • Object classes
  • Methods and characteristics
  • Property inspector

9. forms

  • Create forms
  • Checks in forms

10. communication with other programs

  • Communicate with other Office programs

11. error handling and troubleshooting

  • Field types
  • Direct window
  • Troubleshooting
  • Breakpoints
  • Error handling and compilation

 

Course Overview

20 450 kr

3 days

,

,

Can’t find a (suitable) date, but are interested in the course? Send in an expression of interest and we will do what we can to find a suitable opportunity.

Register interest

Customized Courses

The course can be adapted from several perspectives:

  • Content and focus area
  • Extent and scope
  • Delivery approach

In interaction with the course leader, we ensure that the course meets your needs.

Contact us

Stockholm

  • Tegnérlunden 3
    111 61 Stockholm
  • +46 8 587 116 10

Göteborg

  • Kungsportsavenyen 37
    411 36 Göteborg
  • +46 31 313 94 20

Skicka intresseanmälan för utbildningen

Send an expression of interest for the training