A

Absolute references, denoting, 122 Activate() event, 57, 211, 212, 392

playing a hand of Blackjack and, 252 shuffling deck for Blackjack program and,

248,249 of UserForm object, 314, 315 Activate() method of Range object, 349 of Worksheet object, 158 ActiveCell property, 161

ActiveX controls, 9, 11, 18, 151, 184, 203, 266, 440 adding to forms, 212-213 adding to Math Game program, 134-136 in Blackjack game, 239 Enabled property of, 82 forms customized with, 208 within Frame control, 218 on Math Game worksheet, 125 property settings of, for summary stats custom dialog, 227 UserForms for, 207 VBA shapes and, 436, 437, 438 ActiveX Data Objects (ADO), 296 AddChartSheet() sub procedure, 388, 389, 390 AddCommandButton() sub procedure, 437 AddEmbeddedChart() sub procedure, 390 AddItem() method of Combo Box control, 225, 226, 229, 232 of List Box control, 225, 226, 229, 232 Addition operator (+), 33 AddLine() method, 429 Add() method, 164

of ChartObjects collection object, 391 of Charts collection object, 388 of FileDialogFilters collection object, 287 of Shapes collection, 429 AddOLEObject() method, 429, 437 AddPicture() method, 429

of Shapes collection object, 469 AddPolyline() method, 429 Add Procedure dialog box, 60 AddRecToWorksheet() sub procedure, 309

AddSeries() sub procedure, 405

AddShape() method, 429, 431

AddShape() sub procedure, 448, 449

AddToControls() sub procedure, 309

AddToFile() sub procedure, 309

AddUserInput(), sub procedure, 62

Add Watch dialog box, 278

AddWorkbooks() sub procedure, 164

ADO. See ActiveX Data Objects

After argument, outputting results of hand to

Blackjack worksheet and, 265 AfterUpdate() event, 230 Alienated Game program, 377, 396-425 capturing user selections, 399 chart sheet interface, 398 coding, 402-425

initializing chart sheet, 403-407 playing the game, 420-425 scanning chart, 408-420 designing, 397-402 mapping images, 399-401 outline for, 402 playing the game, 420-425 requirements of, 397 AllowMultiSelect property, of FileDialog object, 287, 288

Ampersand character (&), for concatenation, 47 AND operator, 69

truth table for, 70 Angle brackets (<>), around HTML tags, 331 ANSI character set, 282 Answers collecting, in Math Game program, 143-145 scoring, in Math Game program, 145-147 A1 style references, 120-122 Apostrophes ('), in comments, 20 Application object, 125, 137, 150, 160-161, 205 Cells property of, 172 FileDialog property of, 284 MoveAfterReturn property of, 366 OnKey() method of, 443 Version property of, 215 ApplyDataLabels() method, of Point object, 395 Area chart, 384, 385

Arg1, 394, 399, 420 Arg2, 394, 395, 399, 420 Arguments, 40 Array() function, 433 Arrays, 99, 109-120, 369 defined, 109 dynamic, 116-120 multi-dimensional, 114-116 one-dimensional, 111-114 Artificial intelligence (AI), 178

ASCII characters, random numbers converted to, 323

ASCII conversion characters, selected, 106

Assert() method, of Debug object, 276

Assign Macro dialog box, 133, 436

Assignment operator (=), 33, 72

AssignSelection() function, 422

AssignShipToLocation() function, 194, 196

Authentication, 4

AutoFill() method, 121, 122

AutoFit() method, of Range object, 171

AutoShapes, 427, 447, 449

AutoShape type, 432

AutoSize property, 241

AVERAGE() function, 65, 68, 271

Axes collection object, 389

Axes() method, 389

Axis object, 392

AxisTitle object, 414

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