MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2007 VBA


January 2008

Excel 2007 VBA

I can't believe what you can do with Excel 2007 VBA! This training got me up to speed!

Order Excel 2007 VBA »

Unleash the Power of Excel 2007 VBA

VBA is the macro language packaged with every version of Excel since 1995. Using VBA macros, you can do everything from automating redundant tasks for your own use to developing full applications for your co-workers. Even if you took a programming class 10 years ago, Excel VBA seems tough to learn. It is not like the BASIC you are used to. The recorded macros rarely work the way you want them to. This course, developed by college professor Dr. Gerard Verschuuren is the answer. He is author of Excel 2007 Expert and Excel 2007 for Scientists.

Developed and tested for business training, this CD-ROM is ideally suited for self-instruction using a screen shot approach versus an overabundance of text. More than 1,400 slides, with examples drawn from actual cases, are divided into three modules covering VBA basics, how to calculate with VBA, and letting VBA interact with the user.

Completely Visualized!

Learn Excel VBA in full color. Every slide has rich illustrations to demonstrate the concept.

Full Color
Full Color

Self-Paced with Self-Checks!

Click through the slides at your own pace. Every few slides, there will be a multiple choice question to ensure you've mastered recent concepts. These are the same concepts taught during Dr. Verschurren's Excel Seminars. He has taught Excel to 1000's of people. The next best thing to flying to New Hampshire or Massachusetts for the course, it to buy this CD!

Self-Paced with Self-Checks
Self-Paced with Self-Checks

Real World Examples

The examples used during the course are worth the cost of the course alone. Learn how to automate annoying Excel tasks in the process of taking the course.

Real World Examples
Real World Examples

Look at everything you will learn!

You get three complete modules on the CD covering 1,400 slides.

  • Part 1

    1. Object Oriented
    2. Recording Macros
    3. Branch Statements
    4. Interaction
    5. Variables (Value Type)
    6. Variables (Object Type)
    7. Collections
    8. Loop Statements
    9. Variables as Arguments
    10. Pivot Tables and Charts
  • Part 2

    1. Dates and Calendars
    2. The Current-Region
    3. Property WorksheetFunction
    4. Property Formula
    5. Property FormulaR1C1
    6. Custom Functions
    7. Array Functions
    8. 1D- and 2D-Arrays
    9. Customized Arrays
    10. Variant Arrays
  • Part 3

    1. Importing and Exporting
    2. Buttons, Bars, Menus
    3. Application Events
    4. User Forms
    5. Custom Classes
    6. Class Collections
    7. Error Handling
    8. Recycling VBA code
    9. API and DLLs
    10. Digital Signatures

Order Excel 2007 VBA »