Part 1: Recording Macros and Getting Started with VBA
by Richard Mansfield
Mastering VBA for Microsoft Office 365, 2019th Edition
- Acknowledgments
- About the Author
- Introduction
- Part 1: Recording Macros and Getting Started with VBA
- Part 2: Learning How to Work with VBA
- Chapter 6: Working with Variables, Constants, and Enumerations
- Chapter 7: Using Array Variables
- Chapter 8: Finding the Objects, Methods, and Properties You Need
- Part 3: Making Decisions and Using Loops and Functions
- Chapter 9: Using Built-In Functions
- Chapter 10: Creating Your Own Functions
- Chapter 11: Making Decisions in Your Code
- Chapter 12: Using Loops to Repeat Actions
- When Should You Use a Loop?
- Understanding the Basics of Loops
- Using For…Loops for Fixed Repetitions…Loops for Fixed Repetitions
- Using Do…Loops for Variable Numbers of Repetitions…Loops for Variable Numbers of Repetitions
- While…Wend Loops
- Nesting Loops
- Avoiding Infinite Loops
- The Bottom Line
- Part 4: Using Message Boxes, Input Boxes, and Dialog Boxes
- Part 5: Creating Effective Code
- Part 6: Programming the Office Applications
- Chapter 20: Understanding the Word Object Model and Key Objects
- Examining the Word Object Model
- Working with the Documents Collection and the Document Object
- Saving a Document
- Opening a Document
- Closing a Document
- Changing a Document's Template
- Printing a Document
- Working with the ActiveDocument Object
- Working with the Selection Object
- Creating and Using Ranges
- Manipulating Options
- The Bottom Line
- 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 20: Understanding the Word Object Model and Key Objects
Part 1
Recording Macros and Getting Started with VBA
- Chapter 1: Recording and Running Macros in the 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
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.