Excel VBA Programming For DummiesTake control of your spreadsheets and use VBA to create your own custom Excel applications Author and Excel guru John Walkenbach, known to his devoted fans as "Mr. Spreadsheet," guides you through taking your Excel skills to the next level by creating your own customized spreadsheet solutions using Visual Basic for Applications (VBA). This updated edition of this bestselling book shows you how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more.
Add a personal touch to your spreadsheets and present your data the way you want with Excel VBA Programming For Dummies, 3rd Edition. |
Contents
How VBA Works with Excel 31 | 91 |
Working with Range Objects | 115 |
Using VBA and Worksheet Functions | 129 |
Controlling Program Flow and Making Decisions | 143 |
Automatic Procedures and Events | 163 |
Essential VBA Language Elements 93 Chapter 8 Working with Range Objects 115 Chapter 9 Using VBA and Worksheet Functions 129 Chapter 10 C... | 183 |
Bug Extermination Techniques | 197 |
Bug Extermination Techniques 197 Chapter 14 VBA Programming Examples | 209 |
Accessing Your Macros through the User Interface | 307 |
Accessing Your Macros through the User Interface 307 Part V Putting It All Together | 327 |
Creating Worksheet Functions and Living to Tell about It 329 Chapter 21 Creating Excel AddIns | 347 |
Getting Started with Excel VBA Programming 9 | 365 |
Ten VBA Questions and Answers 361 Chapter 23 Almost Ten Excel Resources 365 Chapter 24 Ten VBA Dos and Donts | 369 |
Ten VBA Dos and Donts | 379 |
| 3 | |
How VBA Works with Excel | 31 |
Introduction 1 | 232 |
Communicating with Your Users | 232 |
UserForm Basics | 249 |
Using UserForm Controls | 265 |
Using UserForm Controls 265 Chapter 18 UserForm Techniques and Tricks | 283 |
Introducing the Excel Object Model | 53 |
VBA Sub and Function Procedures | 67 |
Using the Excel Macro Recorder | 79 |
Other editions - View all
Common terms and phrases
Access active add-in added appears Application argument array assign built-in button Cancel Caption cell Chapter chart choose Close column command CommandBar contains copy create custom default describe determine develop dialog box displays End Sub enter error event example Excel execute Figure formula Frame function Here’s Insert Label ListBox look loop macro message box method modified module Notice object option OptionButtons procedure programming Properties window provides Quick range recorder refer result returns Ribbon right-click selected sheet shortcut menu shown shows simple specify statement steps stored string sure Table TextBox things toolbar True UserForm variable VBA code workbook worksheet worksheet functions write