1Legal Notes and Disclaimer
110UCase
2Chapter 1. VBA−OVERVIEW
111Synta
3Application of VBA
112Example
4Accessing VBA Editor
113Left
5Chapter 2. VBA−Excel Macros
114Syntax
6Chapter 3. VBA−EXCELTERMS
115Parameter Description
7Modules
116Example
8Procedure
117Right
9Sub-procedures
118Syntax
10Chapter 4. VBA−Macro Comments
119Parameter Description
11Syntax
120Example
12Parameter Description
121Mid
13Return Values
122Syntax
14Example
123Parameter Description
15Output
124Ltrim
16Chapter 5. Modules, Procedures, and Functions
125Syntax
17Chapter 6. VBA InputBox
126Example
18Syntax
127Rtrim
19Parameter Description
128Syntax
20Example
129Example
21Output
130Trim
22Chapter 7. VBA Variables
131Syntax
23Syntax
132Example
24Data Types
133Len
25Numeric Data Types
134Syntax
26Non-Numeric Data Types
135Example
27Example
136Replace
28Output
137Syntax
29Chapter 8. VBA−Constants
138Parameter Description
30Syntax
139Example
31Example
140Space
32Output
141Syntax
33Chapter 9 VBA−Operators
142Parameter Description
34the arithmetic operators
143Example
35Arithmetic Operators ─ Example
144StrComp
36The Comparison Operators
145Syntax
37Comparison Operators ─ Example
146Parameter Description
38The Logical Operators
147Example
39Logical Operators ─ Example
148StringFunction
40The Concatenation Operators
149Syntax
41Concatenation Operators
150Parameter Description
42Example
151Example
43Example
152StringReverseFunction
44Chapter 10. Vba Decisions
153Syntax
45If Statement
154Example
46Syntax
155Chapter 13. VBA−DateTimeFunction
47FlowDiagram
156DateFunctions
48Example
157CDate Function
49If Else Statement
158CDate
50Syntax
159Syntax
51Flow Diagram
160Example
52Example
161DateAdd Function
53If Elseif - Else statement
162DateAdd
54Syntax
163Syntax
55Flow Diagram
164Parameter Description
56Example
165Example
57Nested If Statement
166DateDiff
58Syntax
167Syntax
59Example
168Parameter Description
60Switch Statement
169Chapter 14. VBA Arrays
61Syntax
170ArrayDeclaration
62Example
171AssigningValuestoanArray
63Chapter 11. VBA Loops
172Example
64For Loop
173Multi-Dimensional Arrays
65Syntax
174Example
66Flow Diagram
175ReDimStatement
67Example
176Syntax
68For Each Loops
177Parameter Description
69Syntax
178Example
70Example
179Chapter 15. VBA User-DefinedFunctions
71WhileWendLoops
180Function Definition
72Syntax
181Syntax
73FlowDiagram
182Calling a Function
74Example
183Chapter 16. VBA Sub Procedure
75Do While Loops
184Example
76Syntax
185Calling Procedures
77Flow Diagram
186Chapter 17. VBA Events
78Example
187WorksheetEvents
79Alternate Syntax
188Example
80Example
189Output
81Do Until Loops
190Workbook Events
82Syntax
191Example
83Flow Diagram
192Output
84Example
193Chapter 18. VBA ErrorHandling
85Alternate Syntax
194SyntaxErrors
86Flow Diagram
195Runtime Errors
87Example
196LogicalErrors
88Loop Control Statements
197ErrObject
89Exit For
198Example
90Syntax
199Error Handling
91Flow Diagram
200Example
92ExitDo
201Chapter 19. VBA ExcelObjects
93Syntax
202ApplicationObjects
94Example
203Example
95Chapter 12 VBA Strings
204WorkbookObjects
96Syntax
205WorksheetObjects
97Examples
206Example
98String Functions
207Range Objects
99Instr
208Chapter 20. VBA-TextFiles
100Syntax
209FileSystemObject(FSO)
101Parameter Description
210Drive
102Example
211Example
103InString Reverse
212Output
104Syntax
213Write Command
105Parameter Description
214Example
106Example
215Output
107LCase
216Chapter 21. VBA Programming Charts
108Syntax
217Chapter 22. VBA UserForms
109Example
