Microsoft Excel VBA Guidebook (Table of Contents)

Microsoft Excel VBA Guidebook, Second Edition, includes 310 information-packed pages. The following is the Table of Contents:

Introduction

• Who this Book is For
• What this Book Covers
• What is Not Covered
• Where to Go Next
• A Word about ExcelTips

Chapter 1: Introducing Macros in Excel

• Understanding VBA
• Introducing the Visual Basic Editor
• Displaying the Developer Tab
• How to Enable Macros
• Creating Macros
• Recording a Macro
• Relative References when Recording Macros
• Writing a Macro from Scratch
• Running Macros
• Editing Macros
• Deleting Macros
• Getting Rid of the "Enable Macros" Notice

Chapter 2: Elements of Macros

• Projects and Modules
• Understanding Procedures
• Subroutines
• Functions
• Procedure Scope
• Adding Comments
• Continuing Lines
• Variables and Operators
• Understanding Data Types
• Understanding Operators
• Using Objects and Collections
• Excel's Object Model
• Exploring Excel's Objects
• Grouping Similar Objects Together
• Assigning Objects to Variables
• Understanding Object Members
• Doing Operations with Methods
• Working with Properties
• Making Sense of Members
• VBA Constants
• Using Literal Constants
• Creating Symbolic Constants
• Excel's Enumerations

Chapter 3: What's In a Name?

• Naming Macros
• Renaming Macros
• Where Macros are Stored
• Specifying a Location when Recording a Macro
• Specifying a Location when Creating a Macro from Scratch
• Event Handlers
• Avoiding Problems with Event Handlers
• Event Handlers and Workbooks
• Event Handlers and Worksheets
• Event Handlers and Charts
• Automatic Macros

Chapter 4: Understanding the VBA Environment

• Displaying the Visual Basic Editor
• Parts of the Environment
• The Menu Bar
• The Toolbar
• The Project Explorer
• The Properties Window
• The Code Window
• The Immediate Window
• The Object Browser
• Getting Help
• Searching for Help
• Navigating the Help System
• Customizing How VBA Works
• Program Options
• Project Properties
• Library References
• Quitting the Visual Basic Editor

Chapter 5: Managing Macros

• Adding Macros to Excel's Interface
• Adding Macros to the Quick Access Toolbar
• Adding Macros to Ribbon Tabs
• Creating Shortcut Keys for Macros
• Exporting Macros
• Importing Macros

Chapter 6: Using Built-In Functions

• The Benefits of Functions
• Date and Time Functions
• How VBA Stores Times and Dates
• Determining Today's Date
• Determining the Current Time
• Getting Both the Time and Date
• Extracting Part of the Date
• Displaying a Weekday Name
• Extracting Part of the Time
• Differences between Two Dates
• Deriving a Date
• String Functions
• Comparing Strings
• Converting Strings
• Creating Strings
• Other String Functions
• Math Functions
• Extracting an Integer
• Generating Random Numbers
• Determining the Sign of a Number
• Positive Values
• Formatting

Chapter 7: Controlling Program Flow

• Conditional Execution
• If ... Then
• Select Case
• Switch
• Looping Structures
• For Loop
• For Each Loop
• Do Loop
• While Loops
• GoTo

Chapter 8: Using Data Structures

• Understanding Arrays
• Setting Up an Array
• Changing Arrays on the Fly
• Multidimensional Arrays
• Getting Information about an Array
• Starting to Count
• User-Defined Data Types

Chapter 9: Dialog Boxes

• Creating a Message Box
• The Message
• The Title
• Icons, Buttons, and Responses
• Getting User Input
• The Prompt
• The Title
• Default Input
• Screen Coordinates
• Built-In Dialog Boxes
• Available Dialog Boxes
• Displaying Dialog Boxes

Chapter 10: Working with Ranges and Selections

• Creating a Range
• Creating a Selection
• Selecting a Specific Cell or Range of Cells
• Selecting a Cell in the Current Row
• Selecting a Range of Cells Relative to the Current Cell
• Working with Rows and Columns
• Editing Information
• Adding Values
• Replacing Values
• Getting Rid of Values
• Affecting Formatting of a Range or Selection
• Making a Cell's Contents Bold or Italic
• Working with Cell Colors
• Checking for Cell Color
• Applying Custom Formatting
• The Text Method
• Discovering Information about a Range or Selection
• Getting Information Using VBA Functions
• Getting Information Using VBA Methods
• How Many Cells are There?
• Working with Named Ranges
• Adding a Named Range
• Deleting a Named Range
• Displaying Information about Named Ranges
• Using Ranges to Remember User Locations
• Understanding Excel's Special Cells

Chapter 11: Working with Worksheets

• The Worksheet Object
• Creating New Worksheets
• Accessing Worksheets
• Copying Worksheets
• Moving Worksheets
• Deleting Worksheets
• Hiding Worksheets
• Adjusting Worksheet Structure
• Merging Cells
• Inserting Cells, Rows, and Columns
• Deleting Cells, Rows, and Columns
• Cutting, Copying, and Pasting
• Setting Row Height and Column Width

Chapter 12: Working with Workbooks

• The Workbook Object
• Creating New Workbooks
• Opening Existing Workbooks
• Getting to a Workbook's Name
• Accessing Workbooks
• Working with Specific Workbooks
• Activating Workbooks
• Saving Workbooks
• The Close Method
• The Save Method
• The SaveAs Method

Chapter 13: Searching and Replacing

• Finding Things
• Find Parameters
• Searching and Searching
• Searching Multiple Worksheets
• Using Find to Modify Your Worksheet
• Replacing Things
• Searching and Replacing Formatting

Chapter 14: Worksheet and User-Defined Functions

• Accessing Worksheet Functions
• Creating User-Defined Functions
• Running Your UDF whenever the Worksheet is Recalculated
• Making Sure a Function Isn't Used as a UDF

Chapter 15: Working with Non-Excel Files

• File Types
• Text Files
• Foreign File Formats
• Import/Export Formats
• File Basics
• Opening a File
• Handling File Errors
• Reading Data Files
• Closing Files
• Types of File Access
• Sequential Files
• Random-Access Files
• Binary Files

Chapter 16: Debugging and Error Handling

• What Are Bugs?
• Syntax-Related Errors
• Logic-Related Errors
• Operation-Related Errors
• Why are Bugs a Problem?
• Keeping Bugs Out
• What is Debugging?
• Getting Rid of Bugs
• Single Stepping
• Breakpoints
• Watch Expressions

Chapter 17: Resources

Description	Download	CD
Microsoft Excel VBA Guidebook	ISBN 978-1-61359-225-0 (4 MB) $24.99	ISBN 978-1-61359-226-7 (310 pages) $29.99

You can also order Microsoft Excel VBA Guidebook by calling our order line: 307-200-0450.