Excel VBA Macro Programming

L

Label control, 98, 263, 272, 277

Label control properties, 98

Labels

converting to numbers , 205 ‚ 208

extracting numbers from, 225 ‚ 226

reversing, 219 ‚ 220

single quote (') character for, 207 ‚ 208

Labels collection, 289

Last name and first name , reversing, 219 ‚ 220

LatestTime parameter (OnTime method), 236

LBound function, 22

LCase function, 46

Left function (strings), 45, 220

Len function, 47

Lighting direction (3-D object), 292

Like operator, 75

List boxes, 99 ‚ 100, 263, 277, 280

ListBox control, 99 ‚ 100, 263

ListBox control properties, 99 ‚ 100

ListBox object AddItem method, 280

Local variables , 14

Lock Project for Viewing option, 300

Logic errors, 78

Logical operators, 71 ‚ 74

LookIn parameters, 272

Looping, 33, 37 ‚ 41

Loops

early exit of, 40 ‚ 41

indenting of, 7

Love Bug virus, 166