Mastering VBA for Office 2010

Front Cover
John Wiley & Sons, Aug 13, 2010 - Computers - 912 pages
A comprehensive guide to the language used to customize Microsoft Office

Visual Basic for Applications (VBA) is the language used for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access. This complete guide shows both IT professionals and novice developers how to master VBA in order to customize the entire Office suite for specific business needs.

  • Office 2010 is the leading productivity suite, and the VBA language enables customizations of all the Office programs; this complete guide gives both novice and experienced programmers the knowledge they need to make maximum use of VBA for Office
  • Supported with real-world examples in Word, Excel, PowerPoint, Outlook, and Access, this book offers clear, systematic tutorials with both intermediate and advanced content
  • Covers learning how to work with VBA; recording macros; using loops and functions; using message boxes, input boxes, and dialog boxes; creating effective code; XML-based files; ActiveX; the developer tab; content controls; add-ins; embedded macros; and security

Mastering VBA for Office 2010 prepares developers to customize all Microsoft Office 2010 applications for the unique needs of their employers.

From inside the book

Contents

Learning How to Work with VBA
105
Making Decisions and Using Loops and Functions
191
Using Message Boxes Input Boxes and Dialog Boxes
293
Creating Effective Code
429
Programming the Office Applications
525
The Bottom Line
811
Index
855
EULA
881
Copyright

Other editions - View all

Common terms and phrases

About the author (2010)

Richard Mansfield is the author or coauthor of more than 40 computer books, includingVisual Basic .NET Power Toolkit, Office 2003 Application Development All-in-One Desk Reference For Dummies, and Programming: A Beginner's Guide. He is the former editor of Compute! magazine. Overall, his books have sold more than half a million copies worldwide and have been translated into 12 languages.

Bibliographic information