| < Day Day Up > |
|
macro code, 34, 35
Macro dialog box, opening, 41, 91
macro helpers for PivotTable presentations, 359
Macro Name box, 29
macro security settings, 36
macro toolbar buttons, 32
macro viruses, 36
macro writer's trick, 356
macros, 29
adding weekday and date, 113
assigning to key sequences, 31
assigning to menu items, 33
assigning to toolbar buttons, 32
breaking up into several procedures, 54
building a new quarterly workbook, 115
calculating the active sheet, 120
creating charts as object variables, 322
creating new sheets, 112
debugging, 34-36
digitally signing, 39
displaying alerts while running, 116
editing or viewing, 41
executing the next step in, 35
implementing security for, 36-40
increasing the Zoom level, 114
intersection of two ranges, 124
iterating through a collection class, 315
locating the ProductList.xls file, 120
monthly totals, 122
one-click access to zoom, 114
pausing, 117
recalculating all open workbooks, 119, 120
recording, 29, 356, 531
removing all unused worksheets, 116
running, 31-34, 93
saving every open workbook, 137
signing with expired certificates, 39
skipping a step in, 35
storing, 55
viewing VBA code for, 29
Macros dialog box, 48
magenta VBA color constant, 219
magnification level, 154
mail. See e-mail messages, sending
Main procedure, 104
main program feature of an EXE component, 248
Make Same Size item on the Format menu, 46
MakeConnection method, 353
MakeOutlookAppointment- LateBinding procedure, 450-52
malware, 36
manual page breaks, 155
Map property, 558
Margin Indicator Bar, 51
marker sequences, 203
MatchEntry property, 413
MatchFound property, 415
MatchRequired property, 415, 430
MAX function, 206, 477
Max property
of ScrollBar control, 411
of SpinButton control, 407
Maximize button, 19
MaxLength property, 406
maxOccurs=unbounded parameter setting, 548
Me keyword, 311, 313, 505
measures, 342, 343
MEDIAN function, 206
median value, 206
Medium macro security level, 37
member of a collection, 108
MemoryUsed property
of PivotCache object, 353
of PivotField object, 355
menu item, assigning a macro to, 33
menu structure, dialog boxes accessing options, 392
menu system, parts of, 365-71
MenuAnimationStyle property, 366
menus
adding items to existing, 382
manipulating for custom add-ins, 365
in Visual Basic Editor, 44-48
message box statement, 67
message boxes
button options for, 68-69
creating, 67-70, 104
displaying, 69, 119
displaying error descriptions, 429
displaying information about charts, 139
with a welcome or information message, 70
messages on the status bar, 67-70, 117
metadata, 6
methods, 27, 107, 119, 300
adding to allow initialization of all properties of a class, 313
characterizing as verbs, 300
of a class, 304
of Command object, 488
of CommandBar object, 367-68
of CommandBarComboBox object, 378-79
of CommandBarControl object, 373-76
of CommandBars collection, 366-67
of Connection object, 484
defining, 309
of Errors collection, 486
of ListObject object, 542-44
of Recordset object, 491-94
for taking action in workbooks, 145-47
of user form controls, 402-4
of Validation object, 187
of XmlMap object, 554-56
of XPath object, 557
Microsoft Access. See Access
Microsoft ActiveX Data Objects 2.7 library, 498
Microsoft Excel. See Excel
Microsoft Excel 11.0 Object Library, 254
Microsoft Excel Object Model, 107, 108
Microsoft Internet Controls object library, 532
Microsoft Internet Transfer Control, 536
Microsoft Jet, 485
Microsoft Office applications. See Office applications
Microsoft Office Excel 2003. See Excel
Microsoft Office Excel Add-in, 239
Microsoft Office Excel item on the View menu, 45
Microsoft Office Excel Objects folder, 42
Microsoft Office Web Components. See Web Components
Microsoft Office Web site, 239
Microsoft OLE DB Provider for ODBC Drivers, 486
Microsoft Outlook. See entries under Outlook
Microsoft SQL Server. See SQL Server
Microsoft Visual Studio .NET. See Visual Studio .NET
Microsoft Windows SharePoint Services. See SharePoint Services
MID function, 202, 204
MIN function, 206, 477
Min property
of ScrollBar control, 411
of SpinButton control, 407
Minimize button, 19
minus sign (-), 134
Minute function, 214
mixed state for a button, 376
modal form, displaying, 399
modality for a message box, 69
MODE function, 206
mode parameter of Open statement, 295
Mode property of Connection object, 484
modeless forms, 399, 400
Modify method, 189
ModifyActiveChart procedure, 328
ModifyChart procedures, 328
ModifySpecificChart procedure, 329
Module item on the Insert menu, 45
module windows, 51
module-level variables
declaring, 63, 259
resetting, 48
modules, 42. See also code modules
adding, 53
copying between projects, 57
creating, 55
deleting, 56
exporting, 56
inserting into current projects, 45
opening, 53
separating code by task, 53
Modules folder, 42
month, weekday and date for the upcoming, 113
Month function, 214
monthly payment on a loan, 208
MonthlyPayment function, 209
MonthName function, 214
Move method
of CommandBarControl object, 374, 375
of Recordset object, 491
of Sheets collection, 153
MoveFirst method, 491
MoveLast method, 491, 493
MoveNext method
in CopyRows routine, 515
of Recordset object, 492, 493
MovePrevious method, 492, 493
MsgBox (message box) function, 67, 68-69
MsgBox procedure, 104
msinet.ocx, 536
msoBarFloating value, 370
msoControlActiveX constant, 372
msoControlAutoCompleteCombo constant, 372
msoControlButton constant, 372
msoControlButton objects, 375, 380
msoControlButtonDropdown constant, 372
msoControlButtonPopup constant, 372
msoControlComboBox constant, 372
msoControlCustom constant, 372
msoControlDropdown constant, 372
msoControlEdit constant, 372
msoControlExpandingGrid constant, 372
msoControlGauge constant, 372
msoControlGenericDropdown constant, 373
msoControlGraphicCombo constant, 373
msoControlGraphicDropdown constant, 373
msoControlGraphicPopup constant, 373
msoControlGrid constant, 373
msoControlLabel constant, 373
msoControlLabelEx constant, 373
msoControlOCXDropdown constant, 373
msoControlPane constant, 373
msoControlPopup constant, 373
msoControlPopup item, 380
msoControlSpinner constant, 373
msoControlSplitButtonMRUPopup constant, 373
msoControlSplitButtonPopup constant, 373
msoControlSplitDropdown constant, 373
msoControlSplitExpandingGrid constant, 373
MsoControlType enumeration, 366, 367
msoControlWorkPane constant, 373
msoFileDialog constants, 292
msoFileType constants, 283
msoFileTypeExcelWorkbooks constant, 283
msoLastModified constants, 284
msoSearchIn constants, 288
multidimensional arrays, 65, 186
multidimensional reports, 341
multi-line If...Then...Else statements, 74
MultiLine property of a text box, 439
Multiline property of TextBox control, 405
multi-line text box control, 440
multi-line text boxes, 405
MultiPage control, 417
containing connection information, 502
hiding tabs, 503
incrementing the Value property, 436
leaving tabs visible in design mode, 502
Page objects contained in, 434
tabs at the top of, 436
MultiPage1_Change event, 437
multiple applications, 465-66
multiple cells, transferring, 185
multiple file types for a search, 286
multiple items, selecting, 413
multiple object variables, 303
MultiRow property, 416
MultiSelect property, 413
multi-step wizard, 431-41
My List Has Headers check box, 540
MyCOMAddinSetup Wizard, 261
MySuppliers.xml file, 549-50
MySuppliers.xsd schema, 558, 560
| < Day Day Up > |
|