Index_V

V

Val function, 45, 50, 207, 225 ‚ 226

Value property for a cell , 128

Value property (Range object), 136, 159

Variable data types, 12, 16 ‚ 18, 22 ‚ 23

Variable-length strings, 19

Variables , 11 ‚ 15

defined as arrays, 14, 20

defining, 13

explicit declaration of, 13

global, 15

implicit declaration of, 12 ‚ 13

local, 14

module-level, 14 ‚ 15

monitoring, 82 ‚ 83

scope and lifetime of, 13

set to Null, 215

shadowing, 15

static, 15

Variants (variant variables), 16 ‚ 18

date/time values stored in, 17

with empty values, 17

with null values, 17 ‚ 18

VarType function, 16

VarType return values, 16

VBA data types, 18 ‚ 19

VBA Project Explorer and code windows , 4 ‚ 7

VBA Project window, 9 ‚ 10

VBA Projects, 4

VBA (Visual Basic for Applications), 1

application modes, 78

learning by examples, 203

VBAProject object, 210

VBE (Visual Basic Editor), 4

Version property (Application object), 146

Virtual Key Codes, table of, 188 ‚ 192

Visible property, 120, 126, 155, 265, 292

Visual Basic compiler, 5

Visual Basic Editor, in Excel, 3 ‚ 10

Visual Basic window (standard), 5