Excel VBA Development

Spreadsheets have been around for many years. Early users of spreadsheets are often fascinated by the macro features of such programmes and many have moved on to become sophisticated users. Advanced users would recognize that they can be more productive at spreadsheet operations through the use of macros. Visual Basic for Applications serves to provide a powerful and easy means to integrate Excel to the Microsoft Office Suite. This course will teach Excel users how to harness additional programming power in the context of building Excel spreadsheets.

Overview of Visual Basic for Applications (VBA)

• VBA Macro Features - VBA versus Visual Basic, Visual Basic Editor
• VBA Applications Development - Launching VBA
• VBA Variables - Data Types, Declaration, Arrays
• VBA Expressions - Operators, String, Logical, Date
• VBA Macros - Properties, Objects, Functions, Procedures, Modules
• VBA Control Structure - Branching, Iteration
• VBA in Excel - ProgrammeF Option, Application Object, Workbook Object, Worksheet Object,

Range Object

• VBA Application Examples - Financial Models

Integrating a VBA Application

• Dialog Boxes & Controls
• Custom Menus
• Custom Toolbars
• Help Files
• Automation Procedures