Book description
Maximize your Excel experience with VBAExcel 2016 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2016. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features. In addition to the procedures, tips, and ideas that will expand your capabilities, this resource provides you with access to over 100 online example Excel workbooks and the Power Utility Pak, found on the Mr. Spreadsheet website.
Understanding how to leverage VBA to improve your Excel programming skills can enhance the quality of deliverables that you produce—and can help you take your career to the next level.
- Explore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniques
- Leverage templates and worksheets that put your new knowledge in action, and reinforce the skills introduced in the text
- Access online resources, including the Power Utility Pak, that supplement the content
- Improve your capabilities regarding Excel programming with VBA, unlocking more of your potential in the office
Excel 2016 Power Programming with VBA is a fundamental resource for intermediate to advanced users who want to polish their skills regarding spreadsheet applications using VBA.
Table of contents
- 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
Product information
- Title: Excel 2016 Power Programming with VBA
- Author(s):
- Release date: February 2016
- Publisher(s): Wiley
- ISBN: 9781119067726
You might also like
book
Excel 2013 Power Programming with VBA
Maximize your Excel 2013 experience using VBA application development The new Excel 2013 boasts updated features, …
book
Excel 2016 VBA and Macros
This is the Rough Cut version of the printed book. SAVE TIME AND SUPERCHARGE EXCEL 2016 …
book
Programming Excel with VBA and .NET
Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every …
book
Writing Excel Macros with VBA, 2nd Edition
Newly updated for Excel 2002, Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as …