Programming with VBA Excel

Unternehmensübergreifende Weiterbildung

An wen richtet sich die Weiterbildung?

Alle Zielgruppen

Dauer

3,00 Tag(e)

Sprache(n) der Dienstleistung

EN FR

Voraussetzungen

Experience in the use of Microsoft Office system products, particularly in Excel, is preferred. No previous programming experience is required.

Ziele

In this hands-on course, you will learn the basics of programming and VBA from the ground up. You will develop the skills needed to automate repetitive tasks, design interfaces for users and increase performance to improve user productivity.

Inhalt

Introduction to VBA

  • Language type
  • Scope of application
  • VBE Environment
  • Program Scope

Macros

  • Recording and running macros
  • Limitations of recorded macros
  • Improved automatically generated VBA code

Introduction to programming

  • Structure of a macro
  • Variables and data types
  • Constants
  • Conditional structures (IF, CASE)
  • Loops (WHILE, FOR)
  • Objects (Methods, Properties, Events)
  • Excel objects (workbook, sheet, etc.)
  • Collections

Debugging

  • Step by step
  • Immediate window
  • Breakpoints

Procedures and Functions

  • Differences
  • Usage
  • Arguments

Message boxes

  • Information boxes
  • Input boxes

Creating a user interface

  • ActiveX controls (TextBox, Combobox, Checkbox, ListBox, etc.)
  • Event Programming

Error handling

  • The GoTo Error structure.
  • Error handling in code.
  • Error Resume.

Exporting code

  • Creation et insertion of addins.

Security

  • The dangers of macros.
  • Security levels.
  • Code protection.

Tips & tricks from Professionals

Veranstaltungsart

Classroom Courses

Diese Weiterbildungen könnten Sie interessieren