Index_V

V

Val function, 242, 246, 615

Validation object, 57, 858

validation rules, in smart forms, 498-99

value and return parameters, 99-100

Value property, 125, 192, 194, 591, 658, 668

Value2 property, 194

VALUES button, 636

Values property, 539

Values setting, 583

var command, 305

variables , 86-96

accessibility of, 79

and computing with whole numbers , 89-90

constants, 91, 95-96

custom data types, 90-91, 96

declaration of, 78-79, 95

definition of, 86-87, 120

fields, 92-95

index range, 94

internal management of, 111-12

life span of, 109-10

links between differing data types, 90

names of, automatic completion of, 77

naming, 87

overview, 86

realm of validity of, 107-12

referring to objects, 135-37

types of, 87-89, 95

Variant variables, 89, 95, 96, 660

and Array expressions, 94

automatic selection of, 92

in binary files, 282

Decimal variable type, 88

VarType function, 89, 243, 246, 368

VarType(variable), 96

VBA code, data processing in, 588-94

displaying Database form, 591

elementary database management, 588-89

filtering form, 590

form letter in Microsoft Word (example), 591-94

inserting, editing, and deleting data, 591

overview, 588

searching for data, 589-90

sorting data, 590

syntax summary, 594-95

VBA development environment, 748-49

VBA library, 130, 132

VBA (Visual Basic for Applications), 4, 5, 6-8, 67

deactivation and deinstallation of functions, 48

disadvantages of, 8-9

in Excel 2002, 48

history of, 6-7

special features of, 7-8

VBComponent object, 153

VBComponent(s), 858

VBE Library, 153-54

VBE object, 800, 859

Vbe6.dll object library, 131, 132

VBIDE (Visual Basic for Applications Extensibility) Library

in Excel 97, 59

hierarchy, 800

methods and properties, 859

vbModeless parameter, 402

VBProject object, 859

Verb method, 776

Version property, 366, 369

VerticalAlignment property, 195

Vertret.xls file, 41

View Object Browser command, 129

View Data or Edit Query in Microsoft Query option, 631

View menu, 604

ViewAccount of This Month command, 605

ViewCall Stack command, 374-75

ViewCar Database command, 604

ViewCriteria command, 636

ViewDefinition command, 78

ViewFull Screen command, 124

ViewImmediate Window command, 76, 81

ViewMembers Database command, 604

ViewObject Browser command, 72

ViewProperties command, 34

ViewProperties Window command, 71

ViewToolbarsCustomize form, 64, 79

ViewToolbarsCustomizeAttach command, 15

ViewToolbarsCustomizeCommands command, 70, 81

ViewToolbarsCustomizeToolbars dialog, 464

ViewToolbox command, 34

views database server, 628

views, defining, 655

ViewsCustomizeCommands command, 463

virus protection, 178-84, 328

discovering viruses on own, 183

Excel 4 auto macros, 184

overview, 178-79

preventing automatic execution of macros, 180-81

viruses in add-ins and templates, 182-83

from Xlstart folder, 336

Visible property, 184, 192, 218, 221, 718-19

VisibleFields( ) method, 717, 728

Visual Basic

ActiveX programming and, 761, 767-72

developing smart tags with, 746

Visual Basic Editor button, 70

Visual Basic for Applications Extensibility. See VBIDE (Visual Basic for Applications Extensibility) Library

Visual Basic for Applications (VBA). See VBA (Visual Basic for Applications)

Visual Basic .NET, running Excel through

ActiveX libraries and, 781-82

closing connection, 783-84

creating connection, 783

example, 784-86

Visual Studio .NET, 747

vocabulary tutor, macros for, 32-39

additional code, 39

constructing forms, 34-35

overview, 32-33

program code for forms, 35-39

volatile method, 313

VolatileTest function, 313

VolumeName property, 269, 302

VPageBreak object, 859

VPageBreaks object, 859