Excel VBA programming for dummies - Kusleika, Dick; Alexander, Michael (Indianapolis John Wiley & Sons Inc., 2021)
Introduction 1 Part 1: Starting Excel VBA Programming 7 Chapter 1: Getting to Know VBA 9 Chapter 2: Building Simple Macros 17 Part 2: Employing VBA with Excel 29 Chapter 3: Working in the Visual Basic Editor 31 Chapter 4: Introducing the Excel Object Model 51 Chapter 5: VBA Sub and Function Procedures 67 Chapter 6: Using the Excel Macro Recorder 83 Part 3: Programming Concepts 97 Chapter 7: Essential VBA Language Elements 99 Chapter 8: Working with Range Objects 119 Chapter 9: Using VBA and Worksheet Functions 135 Chapter 10: Controlling Program Flow and Making Decisions 151 Chapter 11: Automatic Procedures and Events 171 Chapter 12: Error-Handling Techniques 193 Chapter 13: Bug Extermination Techniques 205 Chapter 14: VBA Programming Examples 219 Part 4: Communicating with Your Users 243 Chapter 15: Simple Dialog Boxes 245 Chapter 16: User Form Basics 263 Chapter 17: Using User Form Controls 281 Chapter 18: User Form Techniques and Tricks 301 Chapter 19: Accessing Your Macros through the User Interface 329 Part 5: Putting It All Together 343 Chapter 20: Creating Worksheet Functions 345 Chapter 21: Creating Excel Add-Ins 365 Part 6: The Part of Tens 377 Chapter 22: Ten Handy Visual Basic Editor Tips 379 Chapter 23: Resources for VBA Help 389 Chapter 24: Ten VBA Do’s and Don’ts 395 Index 401
Keywords: Microsoft Excel (Computer file) -- Visual Basic for Applications (Computer program language) -- Electronic spreadsheets. -- Business--Computer programs