Excel® 2016 Power Programming with VBA
by Richard Kusleika, Michael Alexander
Excel 2016 Power Programming with VBA
- Introduction
- Part I: Introduction to Excel VBA
- Chapter 1: Essentials of Spreadsheet Application Development
- Chapter 2: Introducing Visual Basic for Applications
- Chapter 3: VBA Programming Fundamentals
- Chapter 4: Working with VBA Sub Procedures
- Chapter 5: Creating Function Procedures
- Sub Procedures versus Function Procedures
- Why Create Custom Functions?
- An Introductory Function Example
- Function Procedures
- Function Arguments
- Function Examples
- Emulating Excel’s SUM Function
- Extended Date Functions
- Debugging Functions
- Dealing with the Insert Function Dialog Box
- Using Add-Ins to Store Custom Functions
- Using the Windows API
- Chapter 6: Understanding Excel’s Events
- Chapter 7: VBA Programming Examples and Techniques
- Part II: Advanced VBA Techniques
- Chapter 8: Working with Pivot Tables
- 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 Arbitrary 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
- Chapter 11: Working with External Data and Files
- Part III: Working with UserForms
- Chapter 12: Leveraging Custom Dialog Boxes
- 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
- Understanding UserForm Events
- Referencing UserForm Controls
- Customizing the Toolbox
- Creating UserForm Templates
- A UserForm Checklist
- Chapter 14: UserForm Examples
- Chapter 15: Advanced UserForm Techniques
- A Modeless Dialog Box
- Displaying a Progress Indicator
- Creating 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
- Part IV: Developing Excel Applications
- Part V: Appendix
- Advert
- EULA
Credits
- Acquisitions Editor
Stephanie McComb - Project Editor
Kelly Talbot - Technical Editor
Niek Otten - Production Editor
Rebecca Anderson - Copy Editor
Kelly Talbot Editing Services - Manager of Content Development and Assembly
Mary Beth Wakefield - Marketing Director
David Mayhew - Marketing Manager
Carrie Sherrill - Professional Technology & Strategy Director
Barry Pruett - Business Manager
Amy Knies - Executive Editor
Jody Lefevere - Project Coordinator, Cover
Patrick Redmond - Proofreader
Nancy Carrasco - Indexer
Johnna VanHoose Dinse - Cover Designer
Wiley
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.