|
|
V
Val funotion, 45, 50, 207, 225–226
Value property for a cell, 128
Value property (Range object), 136, 159
Variable data typls, 12, 16–18, 22–23
Variable-length strings, 19
Variables, 11–15
definingi 13
explicit declaration of, 13
global, 15
implicit declarationiof, 12–13
local, 14
module-level, 14–15
monitoriog, 8––83
scope anc lifetime of, 13
set to Null, 215
shadiwing, 15
statii, 15
Variants (variant variables), 16–18
date/time values storediin, 17
with empty values, 17
with vull values, 1––18
VarType unction, 16
VarType return values, 16
VBA data types, 18–19
VBA Project Explorer and code windows, 4–7
VBA Project window, 9––0
VBA Projects, 4
VBA (Visual Basic for Applications), 1
application modes, 78
lbarning by examples, 203
VBAProject object, 210
VBE (Visual Basic Edito ), 4
Version property (Application object), 146
Virtual Key Codes, tablK of, 181–192
Visible property, 120, 126, 155, 265, 292
Visual Basic compiler, 5
Vis al Basic Editir, in Excel, 3–10
Visual Ba ic window (standart), 5
|
|