Sitemap of www.excel-vba.com

Programmers Vocabulary

VBA Programming

Visual Basic Editor (VBE)
The Project  Window
The Properties  Window
The Code  Window
Developing Macros in the VBE
Testing Macros in the VBE
Excel Macro Recorder
Modifying Macros in the VBE
VBA Security and Protection
VBA Events

VBA Coding

General Coding Tips
Code for Errors
Code for the Application
Code for the Workbooks
Code for the Worksheets
Range and Cells
Offset
Rows and Columns
Formulas and Values
Special addresses
Pasting and handling errors
Advanced Features
Message Boxes
Database and Filters
Code for Statements
Code for Functions
Code for Variables
External Data and SQL
Other Objects, Other Code

Userforms

Developing Userforms
Userforms Properties
Controls' Properties
Command Buttons
Labels
Text Boxes
Combo Boxes
List Boxes
Check Boxes and Others
Spin Buttons

VBA Macros in Excel 2007

Up to Excel 2007 you didn't need to install the Visual Basic Editor. Unfortunately with Excel 2007 you must specify that VBA be installed when you install Excel from the Office CD. You know it is installed when you see the item "Developer" in the menu bar.

All macros and VBA procedures developed in Excel 1997 and up will work in Excel 2007 except for a few minor changes:

- a function used only by advanced users "FileSearch" doesn't exist anymore. It can be easily replaced by "Dir" that runs in Excel 2007 and in earlier versions of Excel.

- Advanced users who import external data with or without SQL will add these two lines of code at the end of the refresh process:
ActiveSheet.ListObjects("YourQueryName").Unlink
ActiveSheet.ListObjects("YourQueryName").Unlist

- Cells' background and font colors may cause you light problems.

Nothing else has changed in Excel 2007 as far as VBA is concerned. The macro recorder and the Visual Basic Editor are the same...friendly.