Beginning Microsoft Excel VBA Manual Outline

Module: Introduction

Key Module Topics:

• Copyright and support information

• Mouse terminology

• Digital manual and example organization

• Where to find the Excel examples

Module: Excel for Mac Supplementary Manual

Key Module Topics:

• Mouse terminology

• Key capability differences

• Key keyboard differences

• Key VBA differences

• Compatibility issues between Mac and PC

Module 5: VBA Editor and Module Basics For Engineers

Key Module Topics:

• Overview of how VBA can help the engineering process

• VBA editor overview including VBA project, module and procedure overview

• Controlling and typing in VBA modules

• Referencing and integrating VBA engineering projects

• Using the VBA debugger to debug your engineering code

Module 6: VBA Language Basics for Engineers

Key Module Topics:

• VBA variables, constants and arrays (declaring, scope and data typing)

• VBA operators (logical, arithmetic and comparison)

• Control structures (loops and logic decisions)

• Overview of Excel objects, properties and methods

• How to identify and command Excel objects using VBA

• How to use Excel/VBA on-line help

• How to use the VBA macro recorder to record Excel engineering tasks in VBA

• How to use the Object Browser

• How to error proof your VBA code

• Controlling key Excel objects with VBA

• Data processing methods using VBA

• Automated chart construction

Module 7: Function Procedure Design for Engineers

Key Module Topics:

• Benefits of using Function procedures and User Defined Worksheet Functions (UDF's) for engineering tasks

• Function procedure and UDF differences

• How to declare engineering Function procedures and UDF’s in VBA

• How to create arguments for engineering Function procedures and UDF’s

• How to call engineering UDF’s from a worksheet formula

• Calling engineering Function procedures from other VBA procedures

• Function procedure and UDF procedure interface design

• How to pass worksheet ranges as arguments to engineering UDF's

• Returning scalar and array values from UDF’s to worksheet engineering formulas

• Using VBA and Excel Worksheet functions in your engineering procedures

Module 8: VBA Sub Procedure Design For Engineers

Key Module Topics:

• Benefits of using Sub procedures for engineering tasks

• Declaring Sub procedures in VBA

• Creating arguments for Sub procedures

• Calling Sub procedures from other VBA procedures

• Executing Sub procedures via the Macro dialog box

• Executing Sub procedures via shortcut keys

• Executing Sub procedures via engineering graphics

• Executing Sub procedures via events

• Sub procedure interface design

• Sub procedure design tips for engineers

• Property procedure overview