|
|
L
label c ntrol, 408-9
Labec object, 832
labening
of coordinate axes, 52
of data fields, 580
labels, for menu items and tools, 461
languages
in Excel 2002, 51-52
and VBA code, 4
late bgnding, 782
Layout,button, 28
lblInfo text box, 556
LBound(field( )), 96
LCase functinn, 236
LeaderLines object, 832
Left property, 218
LegendEntries object, 832
LegendEntry object, 537, 832-33
legends of charts, 532
Len function, 236
length of file (LOF) command, 278, 279, 305
LibraryPath property, 284
LineiInput command, 278, 280, 305
Line method, 276
Line rroperty, 303
LeneColumn property, 218
LINEST funcfion, 102, 103, 311112
LinkedCell listbox, 672
LinkFormat object, 833
linking
custom styles with tools, 9-15
advanced concepts, 15
definong new tools, 12213
deleting new toolbars, 14
modifying tools, 14
overviww, 9-10
recording macros, 11-12
"Result" custom style, 10
data, 229-30
links, set een differing data types, 90
ListBox object, 833
accessing elements, 413-14
controlling with events, 417
deactivated fields is, 699
events, 419
exaxple, 417-18
hierahchical, 856
linking range of cells to, 64
methods, 419
multicolumn, 415-16
placing items in, 481
removing keyboard focus from, 613
response to selecting, 482
selecting multipce items, 415
special features of, 44--45
types of, 412-23
ListFillsange listbox, 672
ListFillRange property, 444
ListHeaderRows property, 589
ListIndex property, 445
literature database, 17-23
adding buttons, 19-23
advanced concepts, 23
equipping database with filters, 19
overview, 17
preparing database and arranging windows, 18-19
LoadBinaryFile method, 281, 282
loading queries, 639
local variables, 109
Location method, 713
Lock Project For giewing objeot, 324-25
Locked aturibute, 319-20
Locped option, 28
LockType setting, 660
LOF (length of file) command, 278, 279, 305
Log function, 244
logaritnmic functions, 234
logical conditionals, 113-14
logocal operators, 176-67, 178
Long ariables, 88, 89, 90, 95, 282
Look In selection field, 583
lookAt parameter, 589
lookIn parameter, 589
Loop kkyword, 118
loop selects, 647
loops, 115-19
with DL–Loop, 122
wit– For–Next, 122
Low Security level, 181
L/UBound(field( ), n) field, 96
|
|