Index_M

M

Macros

commenting, 140

explained, 3

recording, 138 ‚ 140

storage location for, 3 ‚ 4

Magic add-in, creating, 296 ‚ 302

Mandatory parameters, 130

Masking, Or operator for, 73

Matrix addition, 237 ‚ 240

MemoryFree property (Application object), 144

MemoryTotal property (Application object), 144

MemoryUsed property (Application object), 144

Menu

adding to Excel menu structure, 121, 295 ‚ 299

removing from Excel menu structure, 298 ‚ 300

Message boxes, 64 ‚ 66

code to display, 10

constants for use with, 65

displaying names of worksheets, 134

return values for, 66

title bar and icon for, 64 ‚ 65

using balloons instead of, 287 ‚ 290

using in debugging, 84 ‚ 85

Method parameters, 128

Methods, 126 ‚ 133

calling, 130 ‚ 133

explained, 128, 130

tip text for, 130

Microsoft Access object model, 125

Microsoft ActiveX Data Objects Library, 179

Microsoft ActiveX Data Objects Recordset Library, 179

Microsoft Office Object Library, 161

Microsoft Outlook, driving from Excel, 164 ‚ 166

Microsoft Outlook Object Library, 165

Microsoft Word document

creating an Excel worksheet from within, 166 ‚ 168

creating from within Excel, 161 ‚ 164

Microsoft Word Object Library, 161 ‚ 162

Mid command, 44 ‚ 45

Mid function, 220, 225, 232

Minute function, 59

Mod function, 239, 247

Mod operator, 70

Module-level variables , 14 ‚ 15

Modules, 25 ‚ 26

Month function, 59

Mouse down event, 84

Mouse events (UserForm), 96

MouseMove event (UserForm), 96, 272

Move events (mouse), 272

Move method, 230

MSDN (Microsoft Developer Network), 184

MsgBox command, 7 ‚ 8, 64 ‚ 66

MsoAnimationGetArtsy, 289

MsoAutoShapeType, 280

MsoBalloonTypeButtons, 289

MsoPresetLightingDirection, 292

Multidimensional arrays, 21

Multimedia sounds, playing from within code, 192

MultiPage control, 103 ‚ 104

Multiple conditional statements, 36

Multiple worksheets or workbooks

searching across, 269 ‚ 276

selecting across, 206 ‚ 207

Multiplication (*) operator, 68

Multiply function, user -defined, 28 ‚ 30