Index_L

L

label control, 408-9

Label object, 832

labeling

of coordinate axes, 52

of data fields, 580

LabelRange property, 717, 729

labels, for menu items and tools, 461

languages

in Excel 2002, 51-52

and VBA code, 4

late binding, 782

Layout button, 28

lblInfo text box, 556

LBound function, 94, 101

LBound(field()), 96

LCase function, 236

LeaderLines object, 832

Left function, 236, 713

Left property, 218

Legend object, 536, 537, 832

LegendEntries object, 832

LegendEntry object, 537, 832-33

LegendKey object, 537, 833

legends of charts , 532

Len function, 236

length of file (LOF) command, 278, 279, 305

LibraryPath property, 284

Like operator, 178, 239, 660

Line Input command, 278, 280, 305

Line method, 276

Line property, 303

LineColumn property, 218

LineFormat object, 560, 833

LINEST function, 102, 103, 311-12

LinkedCell listbox, 672

LinkFormat object, 833

linking

custom styles with tools, 9-15

advanced concepts, 15

defining new tools, 12-13

deleting new toolbars , 14

modifying tools, 14

overview, 9-10

recording macros, 11-12

"Result" custom style, 10

data, 229-30

links, between differing data types, 90

ListBox object, 833

listboxes

accessing elements, 413-14

controlling with events, 417

creating, 470, 479-80

deactivated fields in, 699

events, 419

example, 417-18

hierarchical, 856

linking range of cells to, 64

methods , 419

multicolumn, 415-16

placing items in, 481

properties of, 413, 418

removing keyboard focus from, 613

response to selecting, 482

selecting multiple items, 415

special features of, 444-45

types of, 412-13

listdata sheet, 672, 674

ListFillRange 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

LoadMonthReport, 608, 609

Loc function, 278, 279, 305

local variables , 109

Location method, 713

Lock Project For Viewing object, 324-25

Locked attribute, 319-20

Locked option, 28

Locked property, 320, 326

LockType property, 655, 667

LockType setting, 660

LOF (length of file) command, 278, 279, 305

Log function, 244

logarithmic functions, 234

logical conditionals, 113-14

logical operators, 176-77, 178

Long variables, 88, 89, 90, 95, 282

Look In selection field, 583

lookAt parameter, 589

lookIn parameter, 589

Loop keyword, 118

loop selects, 647

loops , 115-19

with DLLoop, 122

with ForNext, 122

Low Security level, 181

L/UBound(field(), n) field, 96