Microsoft(r) Office Excel(r) 2007 Programming
Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 140 key Excel programming techniques, including:
* Assigning digital signatures to macros
*
Setting properties for a project
*
Assigning values to a variable
*
Changing the properties of an object
*
Formatting a numeric expression
*
Processing a runtime error
*
Saving worksheets to another file
*
Displaying a built-in dialog box
*
Creating custom Ribbon tabs
*
Building and debugging add-ins
Extra Apply It
*
"Apply It" and "Extra" sidebars highlight useful tips
*
High-resolution screen shots demonstrate each task
*
Succinct explanations walk you through step by step
*
Two-page lessons break big topics into bite-sized modules
Reihe
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Illustrationen
Maße
Höhe: 23.3 cm
Breite: 18.7 cm
Dicke: 2.1 cm
Gewicht
ISBN-13
978-0-470-13230-2 (9780470132302)
Schweitzer Klassifikation
Denise Etheridge is a certified public accountant as well as the president and founder of Baycon Group, Inc. She publishes Web sites, provides consulting services on accounting-related software, and authors computer-related books. You can visit www.baycongroup.com to view her online tutorials.
Autor*in
Professional Programmer
How to Use This Book.
1 Using Macros and Form Controls.
2 Using the Visual Basic Editor.
3 Introducing Visual Basic for Applications.
4 Introducing the Excel Object Model.
5 Understanding Arrays.
6 Controlling Program Flow.
7 Using Excel Worksheet Functions.
8 Debugging Macros.
9 Working with Workbooks and Files.
10 Working with Worksheets.
11 Defining Ranges.
12 Working with Cells.
13 Creating Dialog Boxes and Customizing the Ribbon.
14 Working with Charts.
15 Automating Procedures with Excel Events.
16 Building Add-Ins.
17 Understanding.
Appendix a: Vba Quick Reference.
Appendix B: Ribbon Controls Quick Reference.
Index.
