Excel VBA Programming For Dummies. Dick Kusleika
4: Introducing the Excel Object Model Working with the Excel Object Model Diving into Object Properties and Methods Finding Out More from VBA Resources Chapter 5: VBA Sub and Function Procedures Understanding Subs versus Functions Naming Subs and Functions Executing Sub procedures Executing Function Procedures Chapter 6: Using the Excel Macro Recorder Recording Basics Preparing to Record Choosing Between Relative and Absolute Mode Watching the Macro Recorder in Action Specifying Recording Options for Your Macro Streamlining Code Generated by the Macro Recorder
7 Part 3: Programming Concepts Chapter 7: Essential VBA Language Elements Using Comments in Your VBA Code Using Variables, Constants, and Data Types Using Assignment Statements Working with Arrays Using Labels Chapter 8: Working with Range Objects Referring to Range Objects Referring to a Range Using Properties Working with Range Object Properties Taking Action with Range Object Methods Chapter 9: Using VBA and Worksheet Functions Understanding Functions Using Built-In VBA Functions Using Worksheet Functions in VBA Using Custom Functions Chapter 10: Controlling Program Flow and Making Decisions Going with the Flow, Dude The GoTo Statement Decisions, Decisions Knocking Your Code for a Loop Using For Each-Next Loops with Collections Chapter 11: Automatic Procedures and Events Preparing for the Big Event Knowing Where to Put the Event Code Writing an Event-Handler Procedure Triggering Workbook Events Using Activation Events Programming Worksheet-Related Events Understanding Events Not Associated with Objects Chapter 12: Error-Handling Techniques Types of Errors An Erroneous Macro Example Alternate Ways of Handling Errors Handling Errors: The Details An Intentional Error Chapter 13: Bug Extermination Techniques Species of Bugs Identifying Bugs Debugging Techniques Using the Debugger’s Tools Bug Reduction Tips Chapter 14: VBA Programming Examples Working with Ranges Changing Excel Settings Working with Charts VBA Speed Tips
8
Part 4: Communicating with Your Users
Chapter 15: Simple Dialog Boxes
Interacting with the User in VBA
Displaying Messages with the MsgBox Function
Getting Data with an Input Box
Allowing the User to Select a File or Folder
Displaying Excel’s Built-In Dialog Boxes
Chapter 16: UserForm Basics
Knowing When to Use a UserForm
Creating UserForms: An Overview
Working with UserForms
A UserForm Example
Chapter