Microsoft Excel 2002 Visual Basic for Applications Step by Step - Softcover

Jacobson, Reed

Softcover

ISBN 10: 0735613591 ISBN 13: 9780735613591

Publisher: Microsoft Press US, 2001

Synopsis

Teach yourself how to use Microsoft® Visual Basic® for Applications (VBA) to take command of Microsoft Excel Version 2002. Choose your own best starting point in this self-paced guide to learn how to automate spreadsheets, write your own functions and procedures, customize menus and toolbars, and more. Easy-to-follow lessons with real-world scenarios and examples show you exactly how to maximize the built-in programming power in Microsoft Excel 2002. Numerous screenshots and a CD full of practice files help you master step-by-step programming procedures. Find out how to create custom solutions with Microsoft Excel and this book—then keep it nearby as an ongoing desktop reference to VBA functions and features. Learn at your own pace how to:

• Use macros to automate simple and complex tasks
• Manipulate workbooks and worksheets
• Explore range objects
• Work with graphical objects
• Build and manipulate PivotTable® objects
• Create loops and conditional statements with Visual Basic
• Use dialog box controls on worksheets
• Create and use custom functions and handle macro errors
• Create custom toolbar buttons, menu commands, command buttons, event handlers, and dialog boxes

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

About this title

From the Publisher

The beginner developer’s personal training system of easy step-by-step lessons and practice files for customizing Excel Version 2002, as well as an ongoing reference resource to VBA functions. The easiest way to teach yourself how to exploit the built-in power of VBA in Excel Version 2002—one step at a time.

From the Author

Excel Version 2002 simplifies the way you access, process, analyze, share, and display important data. Be more productive and efficient - Excel version 2002 gives users more confidence in working with spreadsheets by making more of the existing functionality easier to discover as well as by providing more intelligence to help assure users that they are not making mistakes. Easy access to information - Excel version 2002 is designed to make it easy for anyone to share data with others, connect to important data on the Web or within an organization, and analyze that data to make better decisions. Rich Data Analysis Solutions - Excel version 2002 provides organizations with the tools they need to create rich solutions in Excel and on the Web. With support for XML and improved Office Web Components, Excel version 2002 enables organizations to build rich solutions using the tools in Excel with which they are already familiar. Visual Basic® for Applications (VBA) is the premier development technology for rapidly customizing applications and integrating them with existing data and systems. VBA offers a sophisticated set of programming tools that developers can use to harness the power of packaged and corporate applications. This saves time and money, reduces risks, leverages programmer skills, and delivers solutions tailored to specific business needs.

Edition details

• Publisher: Microsoft Press US
• Publication date: 2001
• ISBN 10: 0735613591
• ISBN 13: 9780735613591
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 336