Excel® VBA: 24-Hour Trainer

Released May 2011

Publisher(s): Wrox

ISBN: 978047089069

Start your free trial

Video description

This unique book-and-DVD package 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-DVD 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-DVD package to get the total learning experience of VBA for Excel!

Chapter 2: Getting Started with Macros 00:07:54
Chapter 4: Working with VBE 00:04:27
Chapter 6: Variables, Data Types and Constants 00:09:11
Chapter 7: Understanding Objects and Collections 00:05:44
Chapter 8: Making Decisions with VBA 00:10:23
Chapter 9: Repeating Actions with Loops 00:06:58
Chapter 10: Working with Arrays 00:11:42
Chapter 11: Automating Procedures with Worksheet Events 00:13:22
Chapter 12: Automating Procedures with Workbook Events 00:10:07
Chapter 13: Using Embedded Controls 00:18:31
Chapter 14: Programming Charts 00:21:28
Chapter 15: Programming PivotTables and PivotCharts 00:11:55
Chapter 16: User Defined Functions 00:09:25
Chapter 17: Debugging Your Code 00:18:13
Chapter 18: Creating Userforms 00:18:56
Chapter 19: Userform Controls and Their Functions 00:32:43
Chapter 20: Advanced Userforms 00:15:56
Chapter 21: Class Modules 00:25:08
Chapter 22: Add-ins 00:11:40
Chapter 23: Managing External Data 00:10:13
Chapter 25: Not Gone, Not Forgotten 00:08:22
Chapter 26: Overview of Office Automation From Excel 00:10:31
Chapter 27: Working with Word from Excel 00:16:56
Chapter 28: Working with Outlook from Excel 00:15:59
Chapter 29: Working with Access from Excel 00:25:42
Chapter 30: Working with PowerPoint from Excel 00:10:12

Product information

Title: Excel® VBA: 24-Hour Trainer
Author(s):
Release date: May 2011
Publisher(s): Wrox
ISBN: 978047089069

book