Download Wiley Excel Programming
Transcript
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 7 Type or edit your code here. 5 6 Press Alt+F11 to return to Excel. The VBE returns you to Excel. Chapter 1: Using Macros and Form Controls Use the VBE to write and edit code. 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. 3