MICROSOFT EXCEL VBA COURSE OVERVIEW


Course Objectives



A 2 Day VBA Programming Course (complex macros) aimed at Advanced Excel users. This course aims to give users an introduction to Visual Basic Programming within the Excel application. By the end of the course, users will be able to create their automated procedures. Users will also have a greater understanding of Visual Basic, unlocking the door to the most popular used programming language throughout the world.

MSExcel

Course Content


Visual Basic environment introduction

Visual Basic controls – events, properties, text, methods, Forms, Focus

Visual Basic definitions – general, event, function, sub procedures and modules

The basic language – syntax, instructions, conditions and loops

Using variables

Text handling – property, functions, strings and variants

Creating forms

Auto-Fill multiple spreadsheet from user-defined prompts

 


Customizing toolbar menus

Creating menus

Auto start macros

Choices – option buttons, scroll bars, check boxes, list boxes, combo boxes

Displaying and printing - message boxes

Dialog Boxes – creating a dialog box, using a dialog box and dialog control

Error handling

Debugging

Opening and editing spreadsheets automatically