XL: History of Changes to Visual Basic for Applications

ID: Q241399


The information in this article applies to:
  • Microsoft Excel 2000
  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Excel for Windows, version 5.0


SUMMARY

Microsoft Visual Basic for Applications was introduced as the primary development language for Microsoft Excel in version 5.0. There have been changes to Visual Basic and the Excel object model in each version of Excel since version 5.0. These changes are documented in the Help file for each version of Excel. This article illustrates how to find the help topics that discuss the changes to Visual Basic and the Excel object model in each version of Excel.


MORE INFORMATION

Microsoft Excel 2000

For more information about the changes to Visual Basic for Applications in Excel 2000, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type What's New for Microsoft Excel 2000 Developers in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about the changes to the Microsoft Office 2000 object model, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type What's New for Microsoft Office Developers in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

NOTE: If the Assistant is not able to answer your query, click the article number below to view the article in the Microsoft Knowledge Base:
Q231955 OFF: Office Assistant Not Answering Visual Basic Questions

Microsoft Excel 97

For more information about the changes to Visual Basic for Applications in Excel 97, from the Visual Basic Editor, click the Office Assistant, type VBA changes, click Search, and then click to view "Changes to the Microsoft Excel 97 Object Model."

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If the Assistant is not able to answer your query, click the article number below to view the article in the Microsoft Knowledge Base:
Q176476 OFF: Office Assistant Not Answering Visual Basic Questions
For additional information about the changes to Visual Basic for Applications from Excel 5.0 to Excel 97, click the article number below to view the article in the Microsoft Knowledge Base:
Q162721 XL97: VBA Macro Behavior Is Different from Excel 5.0 or 7.0

Microsoft Excel version 7.0

For more information about the changes to Visual Basic for Applications in Excel 7.0, type the following in the Answer Wizard and press Search:
What's new in Visual Basic
In the list of topics, double-click the following:
Changes to Visual Basic for Windows 95

Additional query words: XL2000 XL97 XL7 XL5

Keywords : kbdta xlvbainfo
Version : WINDOWS:2000,5.0,97; Win95:7.0
Platform : Win95 WINDOWS
Issue type : kbinfo


Last Reviewed: December 3, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.