Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
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