Excel® 2019 power programming with VBA

Cover -- Title Page -- Copyright -- About the Authors -- About the Technical Editors -- Credits -- Acknowledgments -- Contents at a Glance -- Contents -- Introduction -- Topics Covered -- What You Need to Know -- What You Need to Have -- Conventions Used in This Book -- Excel commands -- Visual Basic Editor commands -- Keyboard conventions -- Typographical conventions -- Mouse conventions -- What the Icons Mean -- How This Book Is Organized -- Part I: Introduction to Excel VBA -- Part II: Advanced VBA Techniques -- Part III: Working with UserForms -- Part IV: Developing Excel Applications -- Part V: Appendix -- How to Use This Book -- What's on the Website -- Part I Introduction to Excel VBA -- Chapter 1 Essentials of Spreadsheet Application Development -- What Is a Spreadsheet Application? -- Steps for Application Development -- Determining User Needs -- Planning an Application That Meets User Needs -- Determining the Most Appropriate User Interface -- Customizing the Ribbon -- Customizing shortcut menus -- Creating shortcut keys -- Creating custom dialog boxes -- Using ActiveX controls on a worksheet -- Executing the development effort -- Concerning Yourself with the End User -- Testing the application -- Making the application bulletproof -- Making the application aesthetically appealing and intuitive -- Creating a user Help system -- Documenting the development effort -- Distributing the application to the user -- Updating the application when necessary -- Other Development Issues -- The user's installed version of Excel -- Language issues -- System speed -- Video modes -- Chapter 2 Introducing Visual Basic for Applications -- Getting a Head Start with the Macro Recorder -- Creating your first macro -- Examining your macro -- Testing your macro -- Editing your macro -- Comparing absolute and relative macro recording.