MS Excel Version 2002 Visual Basic for Applications, Step by Step - Softcover

MICROSOFT

Softcover

ISBN 10: 0735613591 ISBN 13: 9780735613591

Verlag: Microsoft Press, 2001

Inhaltsangabe

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

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Über diesen Titel

Über die Autorin bzw. den Autor

Reed Jacobson is a senior architect in Hitachi Consulting’s Business Intelligence practice. He has authored several training courses and books, including Microsoft SQL Server 2000 Analysis Services Step by Step.

Details zur Ausgabe

• Verlag: Microsoft Press
• Erscheinungsdatum: 2001
• Sprache: Englisch
• ISBN 10: 0735613591
• ISBN 13: 9780735613591
• Einband: Tapa blanda
• Anzahl der Seiten: 336
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: Nicht verfügbar