In A Sentence
vbafasttrack.com provides the best Excel VBA courses, tutorials, tools and training. Period.
Latest News
New Site
Finally the new site is up and running. With a fresh new look, improved navigation, more code and a face-lift for our favourite coding tool CodeLib. We hope you enjoy your time here and find what you're looking for..
VBA Courses - Questions To Ask
If you are considering investing in an Excel VBA course, we have a list of the questions that you should ask before signing up. As a hint, not many course providers will be able to answer yes to these questions..
Read more...The 10 Commandments
One of our most popular and recommended features is our very own, world famous, 10 Commandments of Excel VBA. Do yourself a favor and have a read.
Read more...You are here:
Excel VBA - 2003 Courseware
- Details
- Category: Latest News
Below are the contents of the Excel 2003 courseware:
184 Pages
Black & White Printing
|
Recorded Macros • Setting Macro Security Levels • Running A Recorded Macro • Relative Cell References • Running A Macro With Relative Cell References • Viewing A Macro Module • Modifying A Recorded Macro • Recorded Macros Quick Reference • Preparing Data For An Application • Recording A Summation Macro • Recording Consolidations • Recording Divisional Macros • Testing Macros • Creating Objects To Run Macros • Assigning A Macro To An Object • Recorder Workshop Quick Reference • User-Defined Functions Theory • Creating Simple User-Defined Functions • Using User-Defined Functions • Using Multiple Arguments • Modifying A Function • Creating A Function Library • User-Defined Functions Quick Reference • Opening And Closing The Editor • Working With The Project Explorer • Working With The Properties Window • Working With The Work Area • Working With A Code Module • Running Procedures From The Editor • Setting Breakpoints In The Editor • Stepping Through A Procedure • Using The VBA Editor Quick Reference |
Understanding VBA • VBA Terminology • Accessing The Excel Object Model • Using The Immediate Window • Working With Object Collections • Setting Property Values • Working With Worksheets • Using The Object Browser • Programming With The Object Browser • Understanding VBA Quick Reference • Creating A Command Procedure • Making Sense Of IntelliSense • Using The Edit Toolbar • Commenting Statements • Indenting Code • Bookmarking In Procedures • Procedures Quick Reference • Creating And Using Variables • Implicit & Explicit Declarations • The Scope Of Variables • Procedure Level Scoping • Module Level Scoping • Passing Variables By Reference • Passing Variables By Value • Data Types • Declaring Data Types • Using Arrays • Using Variables Quick Reference • Application Methods And Properties • Workbook Methods And Properties • Viewing Excel And The Editor Together • Using Workbook Objects • Worksheet Methods And Properties • Using Worksheet Objects • Range Methods And Properties • Using Range Objects • Project – Using Objects In Procedures • Using Excel Objects Quick Reference |
Programming Techniques • The MsgBox Function • Sending Messages To The User • InputBox Techniques • Using The InputBox Function • Using The InputBox Method • The IF Statement • Using IF For Single Conditions • Using IF For Multiple Conditions • The FOR NEXT Statement • Looping With Known Or Specified Iterations • The DO LOOP Statement • Looping With Unknown Iterations • Programming Techniques Quick Reference • Creating A Custom Form • Adding Text Boxes To A Form • Changing Text Box Control Properties • Adding Label Controls To A Form • Adding A Combo Box Control • Adding Option Buttons • Adding Command Buttons • Running A Custom Form • Creating Custom Forms Quick Reference • Initialising A Form • Closing A Form • Project – Transferring Data From A Form • Running Form Procedures • Creating Error Checking Procedures • Running A Form From A Procedure • Programming Custom Forms Quick Reference • Creating A New Menu • Creating A Cascade Menu • Adding Menu Commands • Assigning Macros To Menu Commands • Removing A menu • Custom Menus Quick Reference • Programming Automatic Procedures • Running Automatic Procedures • Automatically Starting A Workbook • Quick Reference |
Custom Development
In addition to the production of coding tools and provision of courses, vbafasttrack.com also offers custom development services using Excel VBA as the core tool / environment. Solutions developed by us are currently in use in many companies, including:
Contact us today for a quote. We offer the best service and, if required, ultra-fast turnaround.
Bespoke Training
If your company has specific training needs that aren't met by our standard course content, enquire about having bespoke training materials produced for your firm.