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
Python for Excel
While Excel remains ubiquitous in the business world, recent Microsoft feedback forums are full of requests …
book
VB & VBA in a Nutshell: The Language
The online documentation of VB/VBA language components seems to follow the 80/20 rule: the basic facts …
book
Programming Excel with VBA: A Practical Real-World Guide
Learn to harness the power of Visual Basic for Applications (VBA) in Microsoft Excel to develop …
book
Learn Data Mining Through Excel: A Step-by-Step Approach for Understanding Machine Learning Methods
Use popular data mining techniques in Microsoft Excel to better understand machine learning methods. Software tools …