Datasheet

3
5
6
You can also use Microsoft Visual Studio Tools for the Microsoft Office System (Visual Studio) to develop programs
for Microsoft Office products. With Visual Studio, you can write in languages such as Visual Basic .NET, Visual C#,
and Managed Extensions for C++. Visual Studio is not part of Microsoft Office; you must purchase it. Microsoft
supports both VBA and Visual Studio.
Visual Studio is more difficult to learn than VBA, and setting up and using Visual Studio is much more difficult than
setting up and using VBA. However, Visual Studio offers better security, a more sophisticated development
environment, and built-in Web services.
The VBE returns you to Excel.
Use the VBE to write and edit code.
Note: See Chapter 2 to learn more about
the VBE.
5 Click the proper module to access
your macros or the VBA code you
have written.
6 Type or edit your code here.
7 Press Alt+F11 to return to Excel.
Chapter 1: Using Macros and Form Controls
03_591598-ch01.indd 303_591598-ch01.indd 3 6/11/10 1:41 PM6/11/10 1:41 PM