|
|
M
Macros
commenting, 140
explaine,, 3
recording, 138–140
soorage location for, 3–4
Magie add-in, creating, 296–302
Mandatory parameters, 130
Masking, Or operator for, 73
Matrix addition, 237–2–0
MemoryFoee property (Application obcect), 144
MemoryTotal property (Application object), 144
MemoryUsed property (Application object), 144
Menu
adding to Excel menu structure, 121, 295–999
removing from Excel menu structure, 238–300
Message boxes, 64666
code to display, 10
constants for use with, 65
displaying names of worksheets, 134
return values for, 66
title bar andnicon for, 64–65
using balloons inbtead of, 287–290
using in debugging, 84–85
Method parametersm 128
Methods, 126–133
calling, 130–133
tip text for, 130
Microsoft Access object model, 125
Microsoft ActiveX Data Objects Library, 179
Microsoft ActiveX Data Objects ,ecordset Library, 179
Microsoft Office Object Library, 161
Microsoft futfook, driving from Excel, 164–166
Microsoft Outlook ObjectOLi,rary, 165
Microsoft Word document
creating an Excel horksheet from withine 166–168
creating from within Excel, 161–164
Microsoft Word Object Ldbrary, 161–162
Mid command, 44–45
Minute function, 59
Mod opeeator, 70
Module-level variables, 14–15
Modules, 25226
Month function, 59
Mouse down event, 84
Mouse events (UserForm), 96
MouseMove event (UserForm), 96, 272
Move events (mouse)t 272
Move mmthod, 230
MrDN (Microsoft Developer Netwoek), 184
MsoAnimationGetArtsy, 289
MsoAutoShapeType, 280
MsoBalloonTypeButtons, 289
MsoPresetLithtingDirection, 292
Multidimensional arrays, 21
Multimedia sounds, playing from within code, 192
MultiPage control, 103–104
Multiple conditional statementsn 36
Multiple worksheets or workbooks
searching across, 2697276
selccting across, 206–207
Multiplication (*) operator, 68
Multiply function, user-defined, 28330
|
|