Writing Excel macros with VBA
Newly updated for Excel 2002, Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel. In particular, the book...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Beijing ; Sebastopol, California :
O'Reilly
2002.
|
| Edición: | 2nd ed |
| Colección: | Safari electronic books.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627252606719 |
Tabla de Contenidos:
- Writing Excel Macros with VBA, 2nd Edition; The Book&s Audience; Organization of This Book; The Book&s Text and Sample Code; About the Code; Conventions in this Book; Obtaining the Sample Programs; How to Contact Us; Acknowledgments; 1. Introduction; 1.2. Setting a Chart&s Data Point Labels; 1.3. Topics in Learning Excel Programming; I. The VBA Environment; 2.2. Programming Style; 2.2.2. Readability; 2.2.3. Modularity; 3. The Visual Basic Editor, Part I; 3.1.2. Project Contents; 3.1.2.2. Sheet objects; 3.1.2.3. Standard modules; 3.1.2.4. Class modules; 3.1.2.5. UserForm objects
- 3.2. The Properties Window3.3. The Code Window; 3.3.2. The Object and Procedure List Boxes; 3.3.2.2. A standard module; 3.3.2.3. A UserForm object; 3.4. The Immediate Window; 3.5. Arranging Windows; 4. The Visual Basic Editor, Part II; 4.1.1.2. Tracing code; 4.1.1.3. Bookmarks; 4.2. Getting Help; 4.3. Creating a Procedure; 4.4. Run Time, Design Time, and Break Mode; 4.5. Errors; 4.5.2. Compile-Time Errors; 4.5.3. Run-Time Errors; 4.5.4. Logical Errors; 4.6. Debugging; 4.6.1.2. Step Over (Shift-F8 or choose Step Over from the Debug menu)
- 4.6.1.3. Step Out (Ctrl-Shift-F8 or choose Step Out from the Debug menu)4.6.1.4. Run To Cursor (Ctrl-F8 or choose Run To Cursor from the Debug menu); 4.6.1.5. Set Next Statement (Ctrl-F9 or choose Set Next Statement from the Debug menu); 4.6.1.6. Breaking out of Debug mode; 4.6.2. Watching Expressions; 4.6.2.2. The Locals and Watches windows; 4.7. Macros; 4.7.2. Running Macros; II. The VBA Programming Language; 5.2. Line Continuation; 5.3. Constants; 5.4. Variables and Data Types; 5.4.2. The Importance of Explicit Variable Declaration; 5.4.3. Numeric Data Types; 5.4.4. Boolean Data Type
- 5.4.5. String Data Type5.4.6. Date Data Type; 5.4.7. Variant Data Type; 5.4.8. Excel Object Data Types; 5.4.8.2. The Set statement; 5.4.9. Arrays; 5.4.9.2. Dynamic arrays; 5.4.9.3. The UBound function; 5.4.10. Variable Naming Conventions; 5.4.11. Variable Scope; 5.4.11.2. Module-level variables; 5.4.12. Variable Lifetime; 5.4.13. Variable Initialization; 5.5. VBA Operators; 6. Functions and Subroutines; 6.2. Calling Subroutines; 6.3. Parameters and Arguments; 6.3.2. Named Arguments; 6.3.3. ByRef Versus ByVal Parameters; 6.4. Exiting a Procedure; 6.5. Public and Private Procedures
- 6.6. Project References7. Built-in Functions and Statements; 7.2. The InputBox Function; 7.3. VBA String Functions; 7.4. Miscellaneous Functions and Statements; 7.4.1.2. The IsEmpty function; 7.4.1.3. The IsNull function; 7.4.1.4. The IsNumeric function; 7.4.2. The Immediate If Function; 7.4.3. The Switch Function; 7.4.4. Units Conversions; 7.4.5. The Beep Statement; 7.5. Handling Errors in Code; 7.5.2. The Error Object; 7.5.3. The On Error GoTo 0 Statement; 7.5.4. The On Error Resume Next Statement; 7.5.5. The Resume Statement; 8. Control Statements; 8.2. The For Loop; 8.3. The For Each Loop
- 8.4. The Do Loop
