L

Label control

Help system, 788-789

UserForms, 418, 517

labels, animating, 482-485

language elements

assignment statements, 190

comments, 190

function, 190

introduction, 189-190

looping structure, 190

variable declaration statement, 190

variables , 190

language issues, 128

LastInColumn function, 366-368

LastInRow function, 366-368

LastPrinted function, 363

LastSaved function, 363

late binding, 679-680

Layout event, 661

LBound function, 267, 984

LCase function, 984

Left function, 984

Len function, 984

Let statement, 979

Line Input # statement, 844, 979

links, updating, 963

ListAllAddIns procedure, 718

ListBox control

activating sheets, 476-479

Add button, 468-469

AddItem method, 463-464

check boxes, 461

ColumnCount property, 461

ColumnHeads property, 461

columns , multiple, 461

ControlSource property, 461

Delete button, 468-469

height, 461

item transfer, 468-469

items, adding, 461-466

items, moving, 470-472

items, retrieving, 461

items, unique, 464-465

ListStyle property, 461

Move Down button, 470

Move Up button, 470

multicolumn, 472-474

multiple lists, 467-468

MultiSelect property, 461, 466-467

RowSource property, 461-462

selected item, determining, 466

selecting rows, 474-476

selections, 461

Transpose function, 464

UserForms, 418, 450-451

ListFiles procedure, 831-832

listing

files in directory, 831-833

fonts, 351-352

procedures in workbook, 866

shortcut menus , 762-763

ListProcedures procedure, 866

literals, passing to procedures, 253

Load statement, 979

LoadPicture function, 524-526

Loan Amortization Wizard

creating, 805

enhancements, 812

FormHelp, 805

FormMain, 805

FormMain, initializing, 807-808

FormMessage, 805

help, displaying, 808-809

HelpSheet, 805

initial message display, 806-807

introduction, 802-803

ModMain, 805

MultiPage control, 803-804

retrieving settings, 810-812

SaveDefaults procedure, 812

saving settings, 810-812

StartAmortizationWizard procedure, 806

ThisWorkbook, 805

user interface, modifying, 806

UserForm_Initialize procedure, 807-808

using, 803-804

worksheet, creating, 809-810

Loc function, 985

local variables, 200-201

locking

cells , 123

objects, 123

Lock Unlock statement, 979

LOF function, 985

Log function, 985

logarithm of number, 985

logging, Excel usage, 848

Logical functions, category, 308

logical operators, 942

Long data type, 195, 978, 982

Lookup & Reference functions, category, 308

LoopFillRange function, 337-338

looping

bad loops , 228

through charts , 582-584

Do Until loops, 235-236

Do While loops, 232-234

Do-Loop function, 978

For-Next loops, 229-232

selected ranges, 329-332

Lotus 1-2-3, 5-6

lowercase, converting strings to, 984

Lset statement, 979

LTrim function, 985