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
Introduction Is This the Right Book? So You Want to Be a Programmer | 91 |
Programming Concepts Chapter 7 Essential VBA Language Elements | 93 |
Introduction | 94 |
31 | 107 |
Working with Range Objects | 115 |
Using VBA and Worksheet | 129 |
Using Worksheet Functions in VBA | 136 |
Controlling Program Flow and Making Decisions | 143 |
Using multiple sets of OptionButtons | 290 |
Using a UserForm as a progress indicator | 299 |
A Dialog Box Checklist | 305 |
Accessing Your Macros through the User Interface | 307 |
and Living to Tell about | 329 |
Putting It All Together | 330 |
A function with a range argument | 336 |
Using the Insert Function Dialog | 344 |
Automatic Procedures and Events | 163 |
Events Not Associated with Objects | 179 |
ErrorHandling Techniques | 183 |
Bug Extermination Techniques | 194 |
Bug Extermination Techniques | 197 |
Using the VBA debugger | 202 |
VBA Programming | 209 |
Looping through a range efficiently | 214 |
VBA Speed Tips | 225 |
Communicating with Your Users | 232 |
The InputBox Function | 240 |
The GetSaveAsFilename Method | 246 |
UserForm Basics | 249 |
Using UserForm Controls | 265 |
UserForm Techniques and Tricks | 283 |
The Part of Tens Chapter 22 Ten VBA Questions and Answers 361 | 361 |
What Is VBA? | 365 |
An Excursion into Versions 18 | 372 |
Almost Ten Excel Resources | 375 |
Index | 383 |
| 3 | |
| 7 | |
| 8 | |
| 16 | |
How VBA Works with Excel | 33 |
Working with a Code Window | 39 |
Entering code directly Using the macro recorder Copying VBA code Customizing the VBA Environment | 47 |
Introducing the Excel Object Model | 53 |
Other editions - View all
Common terms and phrases
active sheet add-in Application argument array book's website bugs built-in button Cancel Caption cell A1 cell.Value Chapter chart choose Code window column command CommandBar CommandButton contains create custom function data type debugging declare default dialog box displays a message End Sub enter event event-handler procedures execute Exit Sub following example following statement For-Next loop format Function procedure GoTo Help system Here's If-Then Immediate window Integer label ListBox macro recorder message box method Microsoft Excel Microsoft Office MonthNames MsgBox function MultiPage control OptionButtons Private Sub Properties window Quick Access toolbar Range object refer right-click routine ScrollBar shortcut menu specified SpinButton Steve Ballmer Sub procedure tab order TextBox ThisWorkbook True user clicks UserForm variable name VBA code VBA functions VBA module VBA procedure VBA programming version of Excel Visual Basic workbook is opened worksheet functions write