Microsoft Excel : VBA Programming

Microsoft Excel : VBA Programming

Course duration:

2 Day

Course Overview

This course is designed to help delegates develop automated procedures in Excel XP using the Visual Basic for Applications language.

Who Should Attend

Anyone who has some experience of recording macros in Excel, but would now like to learn how to edit the code that the macro creates in order to make it more efficient and specific. Anyone who wishes to control their spreadsheet using VBA code.

What You Will Learn

On this 2-day course, course participants familiar with Excel XP will gain a deeper knowledge of the program. They will be shown how to work record with other databases and external data, advanced expressions, the design of forms, how to work with macros, and how to customise the application.

Pre-requisites

Course participants who have successfully completed an Excel Advanced course or have gained similar knowledge within the work environment.

• Introduction to VBA: Recording a macro. Running a macro. The Integrated Development Environment (IDE)
• Assigning macros: Specifying the location of recorded macros. Assigning shortcut keys to macros
• Assigning a macro to a button on a sheet. Assigning a macro to a button on a command bar
• Understanding and editing code: Objects, Properties, Methods and Events. Adding comments to code. Editing the procedure manually. Absolute and relative references
• Using the Object Browser. Calling Procedures from another procedure. Using the VBA help facilities
• Interactive macros: Creating custom message boxes. Creating custom input boxes.Creating custom forms. Adding controls to a worksheet. Event procedures
• Function macros: Creating a function procedure. Using user defined functions
• Using variables: Declaring and using variables in procedures. Data types.
• Macro development: Program flow control. Looping. Debugging