Index_L

---

L

Label control, 401, 404

adding to a user form, 396

beside a SpinButton control, 408

LabelRange property, 356

labels, 335

landscape mode, 154

landscape orientation, changing, 73

language in regional settings, 124

large files, navigating, 276

LargeButtons property, 366

LargeChange property, 411

Last button, 426

Last Position item on the View menu, 45

LastModified property, 284

LastRow constant, 423, 426

LastRow variable, 427

late binding, 450-52, 454, 465

layering effect of Chart Object Model, 326

Layout button, 344

LayoutForm property, 355

lazy searches, 165

LBound function, 185

leap years, 76

Left Arrow key, 127

Left function, 200

Left property

of ChartObject object, 337

of CommandBar object, 368

of CommandBarControl object, 374

of a user form control, 402

of UserForm object, 398, 399

LeftMargin property, 154

Legend object, 322

LEN function, 197

less than (<) comparison operator, 75

less than or equal to (<=) comparison operator, 75

less than or equal to sign (<=), 473

less than sign (<), 473

Let property routine, 306

Let routine, 304

lifetime of variables, 62

light, creating colors using, 220

lightning bolt, indicating events, 278

Like operator, 474-75

line breaks in a message box, 67

line labels, 82

line numbers for GoTo statements, 82

LineCount property, 405

LINEST function, 4

LineStyle argument, 237

LineStyle property, 236

LinkObject, 542

links

to external data sources, 141

to other workbooks, 130

list box, combo box control operating as, 430

list box controls, initializing, 412

List property

of CommandBarComboBox object, 378

of ListBox control, 412

List toolbar, 9

ListBox control, 412

ListColumns property, 541

ListCount property

of CommandBarComboBox object, 378

of ListBox control, 412

ListHeaderCount property, 378

ListIndex property

of CommandBarComboBox object, 378

of ListBox control, 413

ListObject object, 541-44

ListObjects collection, 543

ListRows property, 541

lists, creating, 9

ListScopeFolderObjects procedure, 288

ListSearchScopeOptions procedure, 287

ListStyle property, 413

ListWidth property, 414

Load method of a user form, 399

LoadBehavior subkey, 250

LoadData method, 316

LoadPicture function, 410

Loan Calculation workbook, 170-71

loan payments, 208, 209

Local parameter

of Open method, 131

of OpenText method, 134

of SaveAs method, 136

Locals window, 45

Locals Window item on View menu, 45

location

for a chart, 323-25

for a PivotTable, 344

Location method, 324, 325, 359

Location property, 323, 325

locked argument, 388

locked cells, protecting, 158

Locked property, 402, 403

log file, generating, 269

LOGEST function, 4

logical loops, 79-81

logical (And) operator, 199

logical value

referring to, 194

returned by the InputBox method, 123

LOGINV function, 4

LOGNORMDIST function, 4

Long data type, 59

Long Integer data type, 62

LookIn property, 282, 291

Lookup Wizard add-in, 240

loops, 77-81

Low macro security setting, 36

lower boundary for an array, 64, 65

---