Working with Pivot Tables
An Introductory Pivot 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
