Info

Macro1_Version4() function, 315

macros. See also names of individual macros assigning to form controls,

17-18 assigning to toolbar buttons, 16-17 cleaning up copying and pasting in single statement, 55 last row, finding, 54 selections, 53-54 variables, 55 With...End With, 56 debugging techniques backing up/moving forward in code, 45 breakpoints, 44-45, 50 hovering, 48 Immediate window,

45-48 running to cursor, 45 stepping through code,

42-45 watches, 48-50 digital signatures, 15 editing, 56-58 examining in Programming window, 22-24

examining in VBE, 36-37 constants, 37-41 optional parameters, 37 properties, 41-42 macro recorder absolute references,

25-27 flaws in, 11-12, 28 macros, recording, 22 relative references, 25-27 naming, 15

Personal Macro Workbook, 16

recording, 15

absolute references,

25-27 preparation, 21 Record Macro dialog box, 15-16 relative references, 25-27 stopping recording, 22 running, 16

ActiveX controls, 494 command buttons,

492-494 custom menus, 481-486 custom toolbars,

487-491 hyperlinks, 495-496 keyboard shortcuts, 491 scheduling canceling previously scheduled macros, 338-339 CaptureData function, 337

DebtClock case study,

340-341 OnTime function, 337 Ready mode, 337-338 running every two minutes, 339-340

running x minutes in the future, 339 ScheduleTheDay function, 337 windows of time for updates, 338 security, 14-15 shortcut keys, 16

manually controlling sort order (pivot tables), 247 maximum values, returning, 99-100

MDB (Multidimensional

Database) files, 401 MeasureLeadtime() function, 269-271

measuring order lead time,

269-271 Medium security (macros), 15

Mehmet Ozgur, Suat, 298 Mehta, Tushar, 505. See also electrical control system case study memory, reading CSV files to, 298-299 menus, custom creating, 481-483 deleting, 482-483 fly-out menus, 485-486 menu items adding, 483-484 grouping, 484-485

Microsoft Script Editor button (Visual Basic toolbar), 14

Miles, Tommy, 295, 300, 303

missing Word objects, troubleshooting, 361

mixed references, 123 mixed text, retrieving numbers from, 93

MktLink.exe program, 336 Moala, Ivan F., 308-309, 316, 322, 324, 466

modeless UserForms, 438 ModifyRightClick() function, 311-312

Module command (Insert menu), 34 modules class modules, 20, 415 collections, creating,

425-427 custom objects, 420-422 events, trapping,

416-419 help buttons case study,

427-429 inserting, 415 Property Get procedure,

422-423 Property Let procedure, 422-423 creating, 19-20 standard modules, 424-425

MouseDown() event, 154, 418

MouseMove() event, 155

MouseUp() event, 155

moving forward in code, 45

MrExcel Consulting, 12

MsgBox() function, 161-162

MSubstitute() function, 92-93

multi-user access with Access, 401

ADO (ActiveX Data Objects), 402-404 case study, 403-404 DAO (Data Access Objects), 402

multicolumn ListBoxes, 450

multidimensional arrays, 380

Multidimensional Database

(MDB) files, 401 MultiFilter() function, 292-293

MultiPage control, 170-171 multiple characters, substituting, 92-93

multiple error handlers, 472 multiple pivot table fields, 258-260

Multiple Roots dialog box, 355

multiplication table, 124-125

MultiplicationTable function, 124 MultiSelect property (ListBox), 167

MyFullNameO function, 77 MyName() function, 77 MySheets() function, 385

0 0

Post a comment