Course Outline

Facilities

  • Create your own toolbar and menu

The data types

  • Conversion to other types
  • The extent and lifetime of variables
  • Operators and their priorities
  • Options modules

Conditional statements

  • Select Case
  • If ... Then ... ElseIf ... Else

Loops

  • When reversing loops
  • For Each loop
  • Instructions loop break (exit)

Debugging

  • Processing step
  • Traps Watches
  • Locals Window
  • Immediate Window
  • Call Stack

Error handling

  • Capturing and handling run-time errors
  • Structures: On Error Resume Next, On Error GoTo label, On Error GoTo 0
  • Data display on the statusbar

Basic optimization

  • ScreenUpdating
  • Measurement of the duration of the macro by the method Timer

VBA Forms

  • Create your own forms
  • Calling a form from the code
  • Use the forms in the spreadsheet
 14 Hours

Number of participants



Price per participant

Testimonials (3)

Related Courses

Access VBA

21 Hours

Excel Advanced with VBA

21 Hours

Visual Basic for Applications (VBA) for Analysts

21 Hours

Excel and VBA Programming for Audit and Finance Professionals

28 Hours

Excel VBA Introduction

14 Hours

VBA For Access & Excel

21 Hours

Visual Basic for Applications (VBA) in Excel - Introduction to programming

21 Hours

Visual Basic for Applications (VBA) in Excel - Advanced

14 Hours

Data and Analytics - from the ground up

42 Hours

Working with spreadsheet in Microsoft Excel

14 Hours

Related Categories

1