Learning Center
Plans & pricing Sign in
Sign Out



									                                                            0208 942 5724

Microsoft Excel VBA
Duration: 2 Days

Get ready to take your Excel applications to the next level by harnessing the power of the VBA
language. Aspect’s Excel VBA course will help you gain more control over your spreadsheets by using
VBA while also showing you how to develop more dynamic Excel applications for other users. From
introductory concepts to advanced developer topics, it guides you through every aspect of Excel

Aspect’s Excel VBA course is the perfect introduction to VBA and shows you how to use it to enhance
Excel. You'll then learn how to work with the key objects and uncover the best ways to gain access to
workbooks, worksheets, and more.

Aspect’s Excel VBA course helps you to create automated spreadsheets for all those repetitive tasks.
VBA can also help to simply complex tasks that need to be performed on a regular basis. At the end
of the course, users will be able to record and run macros, edit the VBA code, build in looping
structures and create custom forms.

Delegates should have proficient knowledge of Microsoft Excel or should have attended all of the
following courses (or similar) prior to this course:

Aspect’s Excel Introduction

Aspect’s Excel Intermediate

Aspect’s Excel Advance

Continued over....

Tel: 0208 942 5724                                                 Email:
                                                  0208 942 5724

Course Topics:
Getting Started                              Declaring and Using Object Variables
Introducing Visual Basic for Applications    Controlling Program Execution
Displaying the Developer Tab                 Understanding Control-of-Flow
Recording a Macro                            Structures
Saving a Macro-Enabled Workbook              Using the If...End If Decision Structures
Running a Macro                              Using the Select Case...End Select
Editing a Macro in the Visual Basic Editor   Structure
Understanding the Development                Using the Do...Loop Structure
Environment                                  Using the For...To...Next Structure
Using Visual Basic Help                      Using the For Each...Next Structure
Understanding Macro Security                 Guidelines for use of Control-of-Flow
Working with Procedures and
Functions                                    Working with Forms and Controls
Understanding Modules                        Understanding UserForms
Creating a Standard Module                   Using the Toolbox
Understanding Procedures                     Working with UserForm Properties,
Creating a Sub Procedure                     Events, and Methods
Calling Procedures                           Understanding Controls
Using the Immediate Window to Call           Setting Control Properties in the
Procedures                                   Properties Window
Creating a Function Procedure                Working with Control Appearance
Naming Procedures                            Setting the Tab Order
Working with the Code Editor                 Populating a Control
                                             Adding Code to Controls
Understanding Objects                        Launching a Form in Code
Understanding Objects
Navigating the Excel Object Hierarchy        Debugging Code
Understanding Collections                    Understanding Errors
Using the Object Browser                     Using Debugging Tools
Working with Properties                      Setting Breakpoints
Using the With Statement                     Stepping through Code
Working with Methods                         Using Break Mode during Run mode
Creating an Event Procedure                  Determining the Value of Expressions

Using Expressions, Variables, and            Handling Errors
Intrinsic Functions                          Understanding Error Handling
Understanding Expressions and                Understanding VBA's Error Trapping
Statements                                   Options
Declaring Variables                          Trapping Errors with the On Error
Understanding Data Types                     Statement
Working with Variable Scope                  Understanding the Err Object
Using Intrinsic Functions                    Writing an Error-Handling Routine
Using Intrinsic Constants                    Working with Inline Error Handling
Using Message Boxes
Using Input Boxes

Tel: 0208 942 5724                                       Email:

To top