Microsoft Excel VBA Guidebook (Table of Contents)

Summary: Creating Excel macros allows you to extend your productivity with Excel. Visual Basic for Applications (VBA) is the programming language used for creating Excel macros. Here is the complete table of contents from the second edition of this expert guide for creating macros.

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 Buy Download
ISBN 978-1-61359-225-0 (4 MB)
$24.99
Buy on CD
ISBN 978-1-61359-226-7 (310 pages)
$29.99

If you would like, instead, a printed copy of Microsoft Excel VBA Guidebook, you can pick one up by placing your order through Amazon, if you prefer.

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