IT trainings > Technical

Excel : Visual Basic

Excel - Visual Basic

Goals

Be able to program with Visual Basic in Excel.

Requirements

Be experienced in Windows and Excel. 

Contents

Introduction

Terminology

  • Key Words
  • Description of an object in VBA

Recording Macros

  • Recording procedure
  • Recording options
  • Manual execution of a macro

The Visual Basic Editor

Creating a procedure –Subroutine

  • Inserting new modules
  • Inserting a new procedure or function
  • Help in the creation process
  • VBA – Toolbar

The Variables

  • Definition and Data types
  • Variable scopes
  • The “Dim as” statement

References and Selections

  • Cell references
  • Object references
  • Selecting a cell or an object

Interaction

  • Inputbox and Msgbox

Conditions

  • The IF statement
  • The SELECT CASE statement

Loops

  • For…Next
  • Do…Loop

Manipulating Objects

User Forms

Custom menus

Debugger

  • Step by step execution
  • Break point
  • Watch / Immediate

Functions

Error Handling

Let’s stay in touch

We'll never share your email address and you can opt out at any time, we promise.