Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
Cooking Tips
ExcelTips (menu)
ExcelTips (ribbon)
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
School Tips
Wedding Tips
WordTips (menu)
WordTips (ribbon)

Advertise on the
ExcelTips Site

Newest Tips

Automatically Protecting After Input

Sorting Data on Protected Worksheets

Sorting with Graphics

Understanding Manual Calculation

Using Color in Headers and Footers

Moving a Chart's Legend

Quickly Updating Values

 

Excel 2007 VBA Differences

Summary: Macros are a great way to extend what you can do with Excel. However, Microsoft often introduces subtle (and sometimes not so subtle) differences in how the macro language is implemented from one version of Excel to another. If you need to know how VBA differs in Excel 2007 when compared to previous versions, you'll appreciate the information in this tip. (This tip works with Microsoft Excel 2007.)

Deon wonders if anyone has compiled a list of differences between Excel 2003 VBA and Excel 2007 VBA. Such a list would be very helpful as he is working on updating older macros to work with the latest version of Excel.

The easiest way to find this information is to follow these steps in Excel 2007:

  1. Press Alt+F11 to display the VBA Editor.
  2. Press F1. The VBA Help system starts. (Click here to see a related figure.)
  3. Click What's New.
  4. Click Object Model Changes Since Microsoft Office 2003. (You could click one of the other options to see changes since earlier versions, if desired.)

At this point you can browse through the available options to see what has changed. If you prefer to access the same information in a browser window instead of in the Help system, simply visit this page:

http://msdn.microsoft.com/en-us/library/bb242669.aspx

The number of changes from VBA in Excel 2003 to VBA in Excel 2007 is not great. But it is important to remember that the limits of the program itself are greatly expanded. For instance, if your old macros only checked for data in 65,536 rows, the number of rows in Excel 2007 has greatly increased. If your macro was written to old limits, you'll want to check to make sure it adjusts properly to the expanded limits.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6767) applies to Microsoft Excel versions: 2007

Remove Some Stress at Tax Time! Doing your personal income taxes can be a royal pain. Why not make the process just a bit less stressful with our 101-question checklist. You can prepare for filing your taxes with confidence, knowing you've covered all your bases.
 
Check out Filing Your Income Taxes Checklist today!