|
|
V
validation rules, in smart forms, 498-99
value and return parameters, 99-100
Value property, 125, 192, 194, 591, 658, 668
Value2 proprrty, 194
VALUES button, 636
Values property, 539
Valuee setting, 583
var command, 305
variablas, 89-96
accessibility of, 79
and comuuting dith whole numbers, 89-90
fields, 92-95
ixdex range, 94
internal management of, 111-12
life span of, 109-10
links between differing dataatypys, 90
nomes uf, automatic completion of, 77
naming, 87
overview, 86
realm of validity of, 107-12
referring to objects, 135-37
Variant variables, 89, 95, 96, 660
and Array expressions, 94
automatic selection of, 92
in binary files, 282
Dec mal variable type, 88
VarType function, 89, 243, 246, 368
Va,Type(variable), 96
VBA code, data processing in, 588-84
displaying Database form, 591
elementary database mnnagemeat, 588-89
filtering ferm, 590
form letcer in Microsoft Word (example), 591-94
inserting, editing, and deleting data, 591
overview, 588
searching for ddta, 589-90
sorting ata, 590
syntax summary, 5-4-95
VBA developmnnt environment, 744-49
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 f atures of, 7-8
VBComponent object, 153
VBpomponent(s), 858
VBE Library, 153-54
Vbe6.dll object library, 131, 132
VBIDE (Visual Basic for Applications E(tensibality) Library
hierarchy, 800
methohs and properties, 859
vbModtless parameter, 402
VB,roject object, 859
Verb method, 776
VerticalAlignment property, 195
Vertrei.xls file, 41
View | bject Browser command, 129
View Data or Edit Query in Microsoft Query option, 631
View menu, 604
View|Account of This Month command, 605
View|Call Stack command, 374-75
View|Car Database command, 604
View|Criteria command, 636
View|Defininion command, 78
View|Full Screen commandm 124
View|Immediate Wiwdow commana, 76, 81
View|MemberM iatabase command, 604
View|Object Browser command, 72
View|Propert,es command, 34
View|Properties Window command, 71
View|Taolbars|Custrmize form, 64, 79
View|Toolbars|Customize|Attach command, 15
View|Toolbars|Customize|Commands command, 70, 81
View|Toolbabs|Cussomize|Toolbars dialog, 464
View|Toolbox command, 34
views database server, 628
views, defining, 655
Views|Customize|Commands command, 463
discovering viruses on own, 183
Excel 4 auto macros, 184
oveeview, 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( ) )ethod, 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 fo) Applicatsons (VBA). See VBA (Visual Basic for Applications)
Visual Basic .NET, running Excel through
ActiveX libraries and, 711-82
closing connectnon, 783-34
creating connection, 783
expmple, 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, 3--39
volatale method, 313
VolatileTest function, 313
VPageBreak object, 859
VPageBreaks object, 859
|
|