Book description
This unique book-and-video package of Excel® VBA: 24-Hour Trainer, helps even non-programmers extend Excel with VBA
Virtually every manual task in Excel can be automated with VBA, which increases your productivity and saves enormous amounts of time. This unique book-and-video package prepares you to get more out of Excel by using Visual Basic for Applications (VBA) to automate many routine or labor-intensive Excel tasks. Microsoft Excel MVP and author Tom Urtis walks through a series of lessons and illustrations, while the accompanying DVD provides demos and screencasts to complement each lesson.
Introduces you to programming with Visual Basic for Applications (VBA), macro composition, and the programming environment
Explains events programming, embedded controls, user forms, message boxes, input boxes, looping, and more
Shows you how to control other Office applications from Excel, such as Word, Outlook, Access, and PowerPoint
Includes enhanced coverage of each lesson on the DVD, which also offers detailed examples
Provides ideas for applying VBA to everyday tasks in a way that's both practical and fun
Use this book-and-video package to get the total learning experience of VBA for Excel!
Table of contents
- Copyright
- ABOUT THE AUTHOR
- ABOUT THE TECHNICAL EDITOR
- CREDITS
- ACKNOWLEDGMENTS
- INTRODUCTION
-
I. Understanding the BASICs
-
1. Introducing VBA
- 1.1. WHAT IS VBA?
- 1.2. A BRIEF HISTORY OF VBA
-
1.3. WHAT VBA CAN DO FOR YOU
- 1.3.1. Automating a Recurring Task
- 1.3.2. Automating a Repetitive Task
- 1.3.3. Running a Macro Automatically if Another Action Takes Place
- 1.3.4. Creating Your Own Worksheet Functions
- 1.3.5. Simplifying the Workbook's Look and Feel for Other Users
- 1.3.6. Controlling Other Office Applications from Excel
- 1.4. LIABILITIES OF VBA
- 1.5. TRY IT
- 2. Getting Started with Macros
- 3. Introducing the Visual Basic Editor
- 4. Working in the VBE
-
1. Introducing VBA
-
II. Diving Deeper into VBA
- 5. Object-oriented Programming — An Overview
- 6. Variables, Data Types, and Constants
- 7. Understanding Objects and Collections
- 8. Making Decisions with VBA
-
III. Beyond the Macro Recorder: Writing Your Own Code
- 9. Repeating Actions with Loops
- 10. Working with Arrays
-
11. Automating Procedures with Worksheet Events
- 11.1. WHAT IS AN "EVENT"?
- 11.2. WORKSHEET EVENTS — AN OVERVIEW
-
11.3. EXAMPLES OF COMMON WORKSHEET EVENTS
- 11.3.1. Worksheet_Change Event
- 11.3.2. Worksheet_SelectionChange Event
- 11.3.3. Worksheet_BeforeDoubleClick Event
- 11.3.4. Worksheet_BeforeRightClick Event
- 11.3.5. Worksheet_FollowHyperlink Event
- 11.3.6. Worksheet_Activate Event
- 11.3.7. Worksheet_Deactivate Event
- 11.3.8. Worksheet_Calculate Event
- 11.3.9. Worksheet_PivotTableUpdate Event
- 11.4. TRY IT
-
12. Automating Procedures with Workbook Events
- 12.1. WORKBOOK EVENTS — AN OVERVIEW
-
12.2. EXAMPLES OF COMMON WORKBOOK EVENTS
- 12.2.1. Workbook_Open Event
- 12.2.2. Workbook_BeforeClose Event
- 12.2.3. Workbook_Activate Event
- 12.2.4. Workbook_Deactivate Event
- 12.2.5. Workbook_SheetChange Event
- 12.2.6. Workbook_SheetSelectionChange Event
- 12.2.7. Workbook_SheetBeforeDoubleClick Event
- 12.2.8. Workbook_SheetBeforeRightClick Event
- 12.2.9. Workbook_SheetPivotTableUpdate Event
- 12.2.10. Workbook_NewSheet Event
- 12.2.11. Workbook_BeforePrint Event
- 12.2.12. Workbook_SheetActivate Event
- 12.2.13. Workbook_SheetDeactivate Event
- 12.2.14. Workbook_BeforeSave Event
- 12.3. TRY IT
- 13. Using Embedded Controls
- 14. Programming Charts
- 15. Programming PivotTables and PivotCharts
- 16. User Defined Functions
-
17. Debugging Your Code
- 17.1. WHAT IS DEBUGGING?
- 17.2. WHAT CAUSES ERRORS?
- 17.3. WEAPONS OF MASS DEBUGGING
- 17.4. TRAPPING ERRORS
- 17.5. TRY IT
-
IV. Advanced Programming Techniques
- 18. Creating UserForms
- 19. UserForm Controls and Their Functions
-
20. Advanced UserForms
- 20.1. THE USERFORM TOOLBAR
- 20.2. MODAL VERSUS MODELESS
- 20.3. DISABLING THE USERFORM'S CLOSE BUTTON
- 20.4. MAXIMIZING YOUR USERFORM'S SIZE
- 20.5. SELECTING AND DISPLAYING PHOTOGRAPHS ON A USERFORM
- 20.6. UNLOADING A USERFORM AUTOMATICALLY
- 20.7. PRE-SORTING THE LISTBOX AND COMBOBOX ITEMS
- 20.8. POPULATING LISTBOXES AND COMBOBOXES WITH UNIQUE ITEMS
- 20.9. DISPLAY A REAL-TIME CHART IN A USERFORM
- 20.10. TRY IT
- 21. Class Modules
- 22. Add-Ins
- 23. Managing External Data
- 24. Data Access with ActiveX Data Objects
- 25. Not Gone, Not Forgotten
-
V. Interacting with Other Office Applications
- 26. Overview of Office Automation from Excel
- 27. Working with Word from Excel
- 28. Working with Outlook from Excel
- 29. Working with Access from Excel
- 30. Working with PowerPoint from Excel
- A. What's on the DVD?
Product information
- Title: Excel® VBA: 24-Hour Trainer
- Author(s):
- Release date: May 2011
- Publisher(s): Wrox
- ISBN: 9780470890691
You might also like
book
Excel VBA Programming For Dummies
Take your data analysis and Excel programming skills to new heights In order to take Excel …
book
Excel VBA Programming For Dummies, 3rd Edition
Take control of your spreadsheets and use VBA to create your own custom Excel applications Author …
book
Excel® 2010 Power Programming with VBA
All the methods and tools you need to successfully program with Excel. John Walkenbach's name is …
book
Excel 2016 Bible
The complete guide to Excel 2016, from Mr. Spreadsheet himself Whether you are just starting out …