Excel 2019 Power Programming with VBA. Michael Alexander
Читать онлайн книгу.
Table Example Creating a More Complex Pivot Table Creating Multiple Pivot Tables Creating a Reverse Pivot Table CHAPTER 9: Working with Charts Getting the Inside Scoop on Charts Creating an Embedded Chart Creating a Chart on a Chart Sheet Modifying Charts Using VBA to Activate a Chart Moving a Chart Using VBA to Deactivate a Chart Determining Whether a Chart Is Activated Deleting from the ChartObjects or Charts Collection Looping Through All Charts Sizing and Aligning ChartObjects Creating Lots of Charts Exporting a Chart Changing the Data Used in a Chart Using VBA to Display Custom Data Labels on a Chart Displaying a Chart in a UserForm Understanding Chart Events Discovering VBA Charting Tricks Working with Sparkline Charts CHAPTER 10: Interacting with Other Applications Understanding Microsoft Office Automation Automating Access from Excel Automating Word from Excel Automating PowerPoint from Excel Automating Outlook from Excel Starting Other Applications from Excel CHAPTER 11: Working with External Data and Files Working with External Data Connections Power Query Basics Using ADO and VBA to Pull External Data Working with Text Files Text File Manipulation Examples Performing Common File Operations Zipping and Unzipping Files
5 Part III: Working with UserForms CHAPTER 12: Leveraging Custom Dialog Boxes Alternatives to UserForms Using an Input Box Using the VBA MsgBox Function Using the Excel GetOpenFilename Method Using the Excel GetSaveAsFilename Method Prompting for a Folder Displaying Excel's Built-in Dialog Boxes Displaying a Data Form CHAPTER 13: Introducing UserForms How Excel Handles Custom Dialog Boxes Inserting a New UserForm Adding Controls to a UserForm Toolbox Controls Adjusting UserForm Controls Adjusting a Control's Properties Displaying a UserForm Closing a UserForm Creating a UserForm: An Example Referencing UserForm Controls Customizing the Toolbox Creating UserForm Templates A UserForm Checklist CHAPTER 14: Looking at UserForm Examples Creating a UserForm “Menu” Selecting Ranges from a UserForm Creating a Splash Screen Disabling a UserForm's Close Button Changing a UserForm's Size Zooming and Scrolling a Sheet from a UserForm Exploring ListBox Techniques Using the MultiPage Control in a UserForm Using an External Control Animating a Label CHAPTER 15: Implementing Advanced UserForm Techniques A Modeless Dialog Box Displaying a Progress Indicator