- Paperback: 432 pages
- Publisher: Wrox; 1 edition (May 3, 2011)
- Language: English
- ISBN-10: 047089069X
- ISBN-13: 978-0470890691
- Product Dimensions: 7.4 x 0.9 x 9.2 inches
- Shipping Weight: 1.8 pounds (View shipping rates and policies)
- Average Customer Review: 9 customer reviews
- Amazon Best Sellers Rank: #1,471,931 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Excel VBA 24-Hour Trainer 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
Customers who viewed this item also viewed
From the Back Cover
Increase your productivity and save time and effort with Excel VBA
This unique book-and-DVD package prepares you to get more out of Excel by using Visual Basic for Applications (VBA) to automate your routine or labor-intensive Excel tasks. Microsoft Excel MVP and author Tom Urtis walks through a series of lessons while the accompanying DVD provides demos to complement each lesson. Urtis takes an in-depth look at how manual tasks in Excel can be programmed with VBA for greater speed, efficiency, and accuracy. You'll learn how to use VBA to manipulate Excel in ways you may never have thought possible.
Excel VBA 24-Hour Trainer:
Introduces you to VBA and discusses topics including object orientedprogramming, variable declaration, objects and collections, and arrays
Teaches you how to write your own macros for programming loops, events, charts, pivot tables and pivot charts, and user-defined functions
Shows you how to customize the look and feel of Excel with UserForms, Input Boxes, Message Boxes, and embedded controls
Examines advanced topics including class modules, add-ins, and retrieving external data with ADO and SQL
Demonstrates how to interact with other Office Applications from Excel, including Word, Access®, PowerPoint®, and Outlook®
Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved.
On the DVD
Don't just learndo!
The lessons within the book are accompanied by an instructional demonstration on the DVD.
Write your own macros
Make decisions with VBA
Repeat actions with loops
Automate procedures with worksheet and workbook events
Work with arrays
Create class modules
Program charts and pivot tables
Interact with Office applications Word, Access, PowerPoint, and Outlook
Manage external data
Debug your code
About the Author
Tom Urtis is a Microsoft Office developer, programmer, instructor, and Microsoft Excel MVP. Tom is founder of Atlas Programming Management (www.atlaspm.com), a Silicon Valley-based Office business solutions company specializing in Excel, providing consulting, development, training, and support of fully customized Office programs for a diverse international clientele.