M

Macro dialog box, 10, 11

Macro language support, disabling, 3

Macro language viruses, 3

Macro projects, digital signing of, 4

Macro Recorder chart types and, 391 starting, 127 Macros attaching to control, from Forms toolbar, 133 defined, 11

naming and storing, 128 recording in Math Game program, 126-132 selecting, 10 Macro security settings, changing in Excel, 3-4 Magic Squares, 34-37 Main() sub procedure, 62, 403 Map argument, 347

Mapping images, in Alienated Games program, 399-401

MapRanges variable, 408

Maps, denormalized, 355

Masked cells, marking in Excetris program, 461

Massachusetts Institute of Technology (MIT), 178

Mathematical operators, in VBA, 33

MathGameFormat macro, 128-130

revised, 131 MathGame() procedure, 140, 141, 143 Math Game program, 100, 123-147, 349-372 ActiveX controls added to, 134-136 coding, 134-136 collecting answers in, 143-145 designing, 124-133 enhancements to, 329-330 outline for, 126

random questions and operators generated in,

138-140 recording macros in, 126-132 requirements for, 123-124 scoring answers in, 145-147 selected properties of ActiveX controls in, 135 starting and initializing, 136-138 starting timer in, 140-143 test for, 332-333, 337-338 worksheet, 147 Math Game program (new version) coding, 357-373

maintaining student list and viewing test results, 361-363

taking test, 364-373 writing tests, 357-361 creating tests, 352-355 designing, 351-355 requirements for, 350-351 taking a test, 351-352 MathGame sub procedure, 366, 367, 369 mathOperators array, 144

mathQuestions array, 144

maxHeight argument, 168

MaxLength property, 299

Max property, of Scroll Bar control, 218, 219

maxWidth argument, 168

MEDIAN() worksheet function, 271

Medium setting, for macro security level, 4

Me keyword, 184

Memory location, in computer, 65 Methods, 150, 162

Microsoft Office 11.0 Object Library, 283 Mid() function, 47

Min property, of Scroll Bar control, 219 Misc Shapes worksheet after execution of LoopThruShapes() sub procedure, 436

after execution of SelectLines() sub procedure, 435 Modal forms, 214-215 Modal UserForms, 266 Modeless forms, 214 Modeless Userforms, 266 Mod operator, 139 Module level variables, 30, 279

in Math Game program, 134, 137 Modules, 28-29, 56 object, 28 standard, 29 MouseDown() event procedure, 58, 59, 63, 392 MouseUp() event procedure, 59, 392 MoveAfterReturn property, 137, 366 MoveImages() sub procedure, 408, 416 MoveLeft() sub procedure, 454 MoveMap sub procedure, 416 MoveRight() sub procedure, 454 MoveShape() sub procedure, 451, 453, 461 MsgBox() function, 208, 215 output with, 41-42 settings for button argument with, 43 MS Paint, 242

Multi-dimensional arrays, 114-116 MultiLine property, 299 MultiPage control, 212, 222-224, 266 Change() event of, 229 Value property of, 229 MultiPage.xls project, 271 Multiplication operator (*), 33, 145 MultiRow property, MultiPage control and, 223 Multitasking, 440 myChart variable, 386 myRange object variable, 176

Biorhythm Awareness

Biorhythm Awareness

Who else wants to take advantage of biorhythm awareness to avoid premature death, escape life threatening diseases, eliminate most of your life altering mistakes and banish catastrophic events from your life.

Get My Free Ebook


Post a comment