Excel 2019 Power Programming with VBA. Michael Alexander

Wizards Emulating the MsgBox Function A UserForm with Movable Controls A UserForm with No Title Bar Simulating a Toolbar with a UserForm Emulating a Task Pane with a UserForm A Resizable UserForm Handling Multiple UserForm Controls with One Event Handler Selecting a Color in a UserForm Displaying a Chart in a UserForm Making a UserForm Semitransparent A Puzzle on a UserForm Video Poker on a UserForm

      6  Part IV: Developing Excel Applications CHAPTER 16: Creating and Using Add-Ins What Is an Add-In? Understanding Excel's Add-in Manager Creating an Add-In An Add-In Example Comparing XLAM and XLSM Files Manipulating Add-Ins with VBA Optimizing the Performance of Add-Ins Special Problems with Add-Ins CHAPTER 17: Working with the Ribbon Ribbon Basics Customizing the Ribbon Creating a Custom Ribbon Using VBA with the Ribbon Creating an Old-Style Toolbar CHAPTER 18: Working with Shortcut Menus CommandBar Overview Referring to Controls in a CommandBar Properties of CommandBar Controls Displaying All Shortcut Menu Items Using VBA to Customize Shortcut Menus Resetting a Shortcut Menu Shortcut Menus and Events CHAPTER 19: Providing Help for Your Applications Help for Your Excel Applications Help Systems That Use Excel Components Displaying Help in a Web Browser Using the HTML Help System CHAPTER 20: Leveraging Class Modules What Is a Class Module? Creating a NumLock Class Coding Properties, Methods, and Events Exposing a QueryTable Event Creating a Class to Hold Classes CHAPTER 21: Understanding Compatibility Issues What Is Compatibility? Types of Compatibility Problems Avoid Using New Features But Will It Work on a Mac? Dealing with 64-Bit Excel Creating an International Application Multilanguage Applications VBA Language Considerations Using Local Properties Identifying System Settings Date and Time Settings

      7  Part V: Appendix: VBA Statements and Functions Reference APPENDIX: VBA Statements and Functions Reference VBA Statements Functions

      8  Index

      9  End User License Agreement

      List of Tables

      1 Chapter 1TABLE 1.1 ActiveX Controls versus Form Controls

      2 Chapter 2TABLE 2.1 Some Useful Properties of the Application Object

      3 Chapter 3TABLE 3.1 VBA Built-in Data TypesTABLE 3.2 Variable ScopeTABLE 3.3 Operator PrecedenceTABLE 3.4 VBA Logical Operators

      4 Chapter 5TABLE 5.1 Function Categories

      5 Chapter 6TABLE 6.1 Commonly Used Workbook EventsTABLE 6.2 Worksheet EventsTABLE 6.3 Commonly Used Events Recognized by the Application ObjectTABLE