Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)

Val function, 987

validation

data entry, 648-651

user entry, 322

UserForms, 436

#VALUE! error, 60

value, selecting cells by, 340-342

Values property, 595

VALUES_FROM_SERIES function, 596

Variable uses an Automation type not supported in Visual Basic error, 992

variable-length strings, 205

variables

data types and, 193

data types, determining, 198, 201

declaring, 197-199, 978, 980

declaring all, 198-199

description, 193

introduction, 137

local, 200-201

local, declaring, 980

module-wide, 202

names , 193-194, 203

object references, assigning, 981

object variables, 211-212

public, 202

public, declaring, 980

scope, 199-203

static, 202

subtypes , 987

writing to text files, 980

variant arrays

arrays of variants and, 940

transferring ranges to, 339

Variant data type, 978

benchmarking, 196

description, 195

variant data type

converting expression to, 982

description, 940

VarType function, 987

VBA (Visual Basic for Applications)

code writing code, 869-871

developers and, 13

obsolesence of, 135

XLM and, 135

VBComponents collection, 863

vbCrLf constant, 291

VBE (Visual Basic Editor)

activating, 139-140

Code window, 141

Code window, maximizing, 144-145

Code window, minimizing, 144-145

custom dialog boxes and, 414

Developer tab, 139

Docking tab, 157

Editor Format tab, 156

Editor tab, 152-155

environment, customizing, 152-157

General tab, 156-157

Immediate window, 141

menu bar, 141

new features, 140

Project Explorer window, 141

Properties window, 422-424

toolbars , 141

UserForms, creating, 414

vbModeless, 488

VBProjects collection

References collection, 863

VBComponents collection, 863

VBProject object, 862

vbTab constant, 291

video modes, 129

video, Windows API, 380-381

View tab (Ribbon), 728

VisiCalc, 4

VLOOKUP, 290

Volatile method, 288