Datasheet

Chapter 1: Using Macros and Form Controls
3
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.
5
6
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.
The VBA returns you to Excel.
04_132302 ch01.qxp 7/27/07 9:19 PM Page 3