Getting Started with the Visual Basic Editor
by Richard Mansfield
Mastering VBA for Microsoft Office 2007, 2nd Edition
- Copyright
- Dear Reader
- Dedication
- Acknowledgments
- About the Author
- Introduction
- Recording Macros and Getting Started with VBA
- Learning How to Work With VBA
- Understanding the Essentials of VBA Syntax
- Working with Variables, Constants, and Enumerations
- Using Array Variables
- What Is an Array?
- Declaring an Array
- Storing Values In An Array
- Multidimensional Arrays
- Declaring a Dynamic Array
- Redimensioning an Array
- Returning Information from an Array
- Erasing an Array
- Finding Out Whether a Variable Is an Array
- Finding the Bounds of an Array
- Sorting an Array
- Searching Through an Array
- The Bottom Line
- Finding the Objects, Methods, and Properties You Need
- Making Decisions and Using Loops and Functions
- Using Message Boxes, Input Boxes, and Dialog Boxes
- Creating Effective Code
- Programming the Office Applications
- Understanding the Word Object Model and Key Objects
- Working with Widely Used Objects in Word
- Understanding the Excel Object Model and Key Objects
- Working with Widely Used Objects in Excel
- Understanding the PowerPoint Object Model and Key Objects
- Working with Shapes and Running SLide Shows
- Understanding the Outlook Object Model and Key Objects
- Working with Events in Outlook
- Understanding the Access Object Model and Key Objects
- Manipulating the Data in an Access Database via VBA
- Accessing One Application from Another Application
- Programming the Office 2007 Ribbon
- Hiding the Editing Group on the Word Ribbon
- Working with Excel and PowerPoint
- Undoing Ribbon Modifications
- Selecting the Scope of Your Ribbon Customization
- Adding a New Group
- Adding Callbacks
- Adding Attributes
- Using Menus and Lists
- Toggling with a Toggle Button Control
- Modifying the Ribbon in Access
- Adding a Callback in Access
- What to Look For if Things Go Wrong
- Where to Go from Here
- The Bottom Line
- The Bottom Line Solutions
- Chapter 1: Recording and Running Macros in theMicrosoft Office Applications
- Chapter 2: Getting Started with the Visual Basic Editor
- Chapter 3: Editing Recorded Macros
- Chapter 4: Creating Code from Scratch in the Visual Basic Editor
- Chapter 5: Understanding the Essentials of VBA Syntax
- Chapter 6:Working with Variables, Constants, and Enumerations
- Chapter 7: Using ArrayVariables
- Chapter 8: Finding theObjects,Methods, and Properties YouNeed
- Chapter 9: Using Functions
- Chapter 10: Creating Your Own Functions
- Chapter 11: Making Decisions in Your Code
- Chapter 12: Using Loops to Repeat Actions
- Chapter 13: Getting User Input with Message Boxes and Input Boxes
- Chapter 14: Creating Simple Custom Dialog Boxes
- Chapter 15: Creating Complex Dialog Boxes
- Chapter 16: Building Modular Code and Using Classes
- Chapter 17: Debugging Your Code and Handling Errors
- Chapter 18: Building Well-Behaved Code
- Chapter 19: Securing Your Code with VBA's Security Features
- Chapter 20: Understanding the Word Object Model and Key Objects
- Chapter 21: Working with Widely Used Objects in Word
- Chapter 22: Understanding the Excel Object Model and Key Objects
- Chapter 23: Working with Widely Used Objects in Excel
- Chapter 24: Understanding the Powerpoint Object Model and Key Objects
- Chapter 25: Working with Shapes and Running Slide Shows
- Chapter 26: Understanding the Outlook Object Model and Key Objects
- Chapter 27: Working with Events in Outlook
- Chapter 28: Understanding the Access Object Model and Key Objects
- Chapter 29: Manipulating the Data in an Access Database via VBA
- Chapter 30: Accessing One Application from Another Application
- Chapter 31: Programming the Office 2007 Ribbon
- Glossary
Chapter 2. Getting Started with the Visual Basic Editor
In this chapter, you'll start learning how to use the Visual Basic Editor, a powerful tool that Microsoft provides for working with VBA code and user forms. This programming editor is the culmination of over 15 years of modifications and improvements. It is highly effective.
All applications that host VBA use the Visual Basic Editor, so when you're working with VBA, the environment looks much the same no matter which application you're using.
This chapter shows you the basics of the Visual Basic Editor: its components, what they do, and how you use them. You'll learn more advanced maneuvers as you work with VBA later in this book.
This chapter also shows you how to customize the Visual Basic Editor to make your work more comfortable. This customization doesn't take long, and you'll find the resulting ease of use more than worth the amount of time you invest.
In this chapter you will learn to:
Open the Visual Basic Editor
Open a macro in the Visual Basic Editor
Understand the Visual Basic Editor's main windows
Set properties for a project
Customize the Visual Basic Editor
-
No Comment