Book description
Master VBA automation quickly and easily to get more out of Excel
Excel VBA 24Hour Trainer, 2nd Edition is the quickstart guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a total of eleven hours of video training and 45 total lessons to teach you the basics and beyond. This selfpaced tutorial explains Excel VBA from the ground up, demonstrating with each advancing lesson how you can increase your productivity. Clear, concise, stepbystep instructions are combined with illustrations, code examples, and downloadable workbooks to give you a practical, indepth learning experience and results that apply to realworld scenarios.
This is your comprehensive guide to becoming a true Excel power user, with multimedia instruction and plenty of handson practice.
Program Excel's newest chart and pivot table object models
Manipulate the user interface to customize the look and feel of a project
Utilize message boxes, input boxes, and loops to yield customized logical results
Interact with and manipulate Word, Access, PowerPoint, and Outlook from Excel
If you're ready to get more out of this incredibly functional program, Excel VBA 24Hour Trainer, 2nd Edition provides the expert instruction and fast, handson learning you need.
Table of contents
 Introduction
 Part I: Understanding the BASICs
 Part II: Diving Deeper into VBA

Part III: Beyond the Macro Recorder: Writing Your Own Code
 Lesson 10: Repeating Actions with Loops
 Lesson 11: Programming Formulas
 Lesson 12: Working with Arrays
 Lesson 13: Automating Procedures with Worksheet Events
 Lesson 14: Automating Procedures with Workbook Events
 Lesson 15: Handling Duplicate Items and Records
 Lesson 16: Using Embedded Controls
 Lesson 17: Programming Charts
 Lesson 18: Programming PivotTables and PivotCharts
 Lesson 19: UserDefined Functions
 Lesson 20: Debugging Your Code

Part IV: Advanced Programming Techniques
 Lesson 21: Creating UserForms
 Lesson 22: UserForm Controls and Their Functions

Lesson 23: Advanced UserForms
 The UserForm Toolbar
 Modal versus Modeless
 Disabling the UserForm's Close Button
 Maximizing Your UserForm's Size
 Selecting and Displaying Photographs on a UserForm
 Unloading a UserForm Automatically
 Presorting the ListBox and ComboBox Items
 Populating ListBoxes and ComboBoxes with Unique Items
 Displaying a RealTime Chart in a UserForm
 Try It
 Lesson 24: Class Modules
 Lesson 25: AddIns
 Lesson 26: Managing External Data
 Lesson 27: Data Access with ActiveX Data Objects
 Lesson 28: Impressing Your Boss (or at Least Your Friends)
 Part V: Interacting with Other Office Applications
 End User License Agreement
Product information
 Title: Excel VBA 24Hour Trainer, 2nd Edition
 Author(s):
 Release date: March 2015
 Publisher(s): Wrox
 ISBN: 9781118991374
You might also like
book
Excel 2016 Power Programming with VBA
Maximize your Excel experience with VBA Excel 2016 Power Programming with VBA is fully updated to …
book
Excel 2019 Power Programming with VBA
Maximize your Excel experience with VBA Excel 2019 Power Programming with VBA is fully updated to …
book
Excel 2019 Bible
The complete guide to Excel 2019 Whether you are just starting out or an Excel novice, …
book
Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, First Edition
Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so …