Programming in the VBA environment

Содержание книги "Programming in the VBA environment "

Introduction
1. Algorithm development. Block diagram. Algorithm structures
1.1. The concept of the algorithm. Algorithm structures
2. Representation of data in memory, data types, identifiers, variables, arrays
2.1. Software method for recording algorithms
2.2. Data representation in memory
2.3. Datatypes
2.4. Identifiers, variables, arrays
2.5. Operations, expressions, operators
3. The VBA program structure, description operators, assignments
3.1. The VBA pro gram structure
3.2. Description operators
3.3. Assignment operators
4. The concept of a macro, creating, debugging a program
4.1. The concept of a macro. Creating a macro
4.2. Debugging, using the environment to debug programs
4.3. Debugging tools
4.4. Runtime Errors Handling
4.5. Error catching
4.6. Understanding Error Trapping
5. VBA control structures
5.1. If ... Then construction
5.2. If ... Then Else construction
5.3. Select Case construction
6. Loop operators. Nested Loops
6.1. Loop operators
6.2. Nested Loops
7. Character data. Operations and functions for operating with character data
7.1. Character data
7.2. Operations and functions for operating with character data
8. Boolean vectors and operations for operating with them
9. Subroutine-procedure
9.1. General procedures
9.2. Creation of new procedures
9.3. Viewing Existing Procedures
9.4. Calling Sub Procedures
9.5. Procedures in Standard Modules
10. Subroutine-function
10.1. Calling Function Procedures
10.2. Parameters passing mechanisms. Parameter data types. Passing parameters by value
10.3. Passing parameters by reference
10.4. Unknown number of parameters
10.5. Recursion
11. Use of objects, their properties and methods. Forms
11.1. Working with objects
11.2. Origin of objects. Object Basics
11.3. Setting property values
11.4. Getting Property Values
11.6. Object relationship
11.7. Applying Properties and Methods to Set Members
11.8. Shared Sets in VBA
11.9. Form development. Form Events and Methods
11.10. Communication between objects. Creation of objects. Using and declaring variables for objects
11.11. Forms as objects. FSO object
12. Controls in VBA Applications
12.1. Control buttons
12.2. Labels
12.3. Text fields
12.4. Working with text in a text field
12.5. Checkboxes
12.6. Creating groups of radio buttons. Selecting switches
12.7. Combined windows and lists
12.8. Scrollbars as input devices
12.9. Graphic window as a container
12.10. Image Control
12.11. Other controls
Bibliography
Appendix 1