Excel VBA Programming For Dummies.
Take 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.
What people are saying - Write a review
How VBA Works with Excel 31
Working with Range Objects
Using VBA and Worksheet Functions
Controlling Program Flow and Making Decisions
Automatic Procedures and Events
Essential VBA Language Elements 93 Chapter 8 Working with Range Objects 115 Chapter 9 Using VBA and Worksheet Functions 129 Chapter 10 C...
Bug Extermination Techniques
Bug Extermination Techniques 197 Chapter 14 VBA Programming Examples
Accessing Your Macros through the User Interface
Accessing Your Macros through the User Interface 307 Part V Putting It All Together
Creating Worksheet Functions and Living to Tell about It 329 Chapter 21 Creating Excel AddIns
Getting Started with Excel VBA Programming 9
Ten VBA Questions and Answers 361 Chapter 23 Almost Ten Excel Resources 365 Chapter 24 Ten VBA Dos and Donts
Ten VBA Dos and Donts
How VBA Works with Excel
Communicating with Your Users
Using UserForm Controls
Using UserForm Controls 265 Chapter 18 UserForm Techniques and Tricks
Introducing the Excel Object Model
VBA Sub and Function Procedures
Using the Excel Macro Recorder