B

Bar chart, 384, 385, 391 Battlecell program, 149-150, 246 coding, 182-202

computer selections: placing ships and firing at player, 192-198

initializing Battlecell and starting game, 185-188 opening and closing Battlecell workbook, 182-185 player selections: placing ships and firing at computer, 188-192

sound added to VBA program, 203-205 validating selections, 198-202 constructing, 177 designing, 180-182 requirements for, 177-180 Battlecell workbook, opening and closing, 182-185 Battlecell worksheet for game in progress, 192

with location of computer's ships, 194

with "Player" range selected, 187

after user has placed four of five ships, 190

Battleship game, Battlecell program based on, 150, 177

BeforeClose() event, of Workbook object, 182, 183, 184, 188

BeforeDragOver() procedure, 80

BeforeDropOrPaste() procedure, 80

Binary code, 5

Binary language, 65

Biorhythms, 48

Biorhythms and the Time of Your Life program, 25 coding, 49-52 constructing, 47-48 design of, 48-49 requirements for, 48 Bitmap image files, for Blackjack game, 242 Bitmaps, 78 Blackjack form, 242 closing, 245 dealer bust and, 263 select properties of, 240-241 Blackjack form module, CalcScore() sub procedure of, 276 Blackjack game, 237 Blackjack program, 208, 237-266 code for, 246-266

general purpose public procedures, 246-247 playing a hand of Blackjack, 252-266 public procedures and variables for, 247 shuffling deck, 248-252 dealer bust in hand of Blackjack, 263 designing, 239, 242-245 player bust in hand of Blackjack, 260 requirements for, 237-239 starting new hand of Blackjack, 257 swapping two cards in deck, 244 writing code for, 246-266 Blackjack() public procedure, in Blackjack program, 248 BonusCall() sub procedure, 469 Bonus points, assigning in Excetris program, 463 Boole, George, 69 Boolean algebra, 69, 70 Boolean data types, 39

Boolean logic, within conditional expressions, 69-70, 97

BorderColor property, 211

Borders, for puzzle area of worksheet, 325

BorderStyle property, 211, 218

Brackets ([]), in R1C1 style references, 122

Branching, conditionals and, 71-76

Break Mode, 274-275

Breakpoints, inserting, 275

Break When Value Changes, 278

Break When Value Is True, 278

Browsers, 330

Bubble chart, 384

in Alienated Game program, 398, 410, 416 Bubble chart type, 396

BubbleScale property, of ChartGroup object, 405 BubbleSort() procedure, 110, 113, 114 BubbleSort2() sub procedure, 113, 116, 117 Bugs, 222, 270

BuildShape() sub procedure, 449 Button variable, 59 ByRef keyword, 63 ByVal keyword, 58, 63

CalcScore() sub procedure, 276, 408, 414

playing a hand of Blackjack and, 259, 260 Call keyword, 62 Capitalization, 37

in API declarations, 204 Caption property, 168, 213, 226 Blackjack game and, 243 changing, 13

of Command Button control, 18 Frame control and, 218 Option Button control and, 216 playing a hand of Blackjack and, 253, 254, 255 CardDeck enumeration, 247 CardSuits enumeration, 247 Case elements, conditionals in, 76 Case keyword, 75 Case sensitivity, 37

with XML tags, 335 CellColors() sub procedure, 177 Cell property, 106 Cells, color of, 15

Cells property, 102, 110, 115, 122, 159 of Range object, 349 using, 172-173 CenterApp() sub procedure, 168 CenterBook() procedure, 168 Central processing unit (CPU), 440 ChangeAllIndices() function procedure, 455, 459 ChangeColor() sub procedure, 386, 387 Change() event procedure of Combo Box control, 229, 316 of MultiPage control, 224, 229 of RefEdit control, 222 of Scroll Bar control, 217, 219

of worksheet, 143 of Worksheet object, 368 Chart events, 392

chart sheets and, 393 ChartFillFormat object, UserPicture() method of, 406 ChartGroup object, BubbleScale property of, 405 Chart object, 153, 155, 174 , 377, 42 5 accessing existing charts, 379 chart sheets, 379-381 embedded charts, 382-383 Alienated Game design and, 397 chart events, 392-396 chart sheets and, 393-396

creating, 388-389 creating embedded charts, 390-392 events, 392, 393 manipulating charts, 383-388 ChartObject object, 382, 383, 386 ChartObjects collection object, 382, 386 Charts, 377, 378 creating, 388 manipulating, 383-388

scanning in Alienated Game program, 408-420 Charts collection object, 378, 379, 380 Chart sheets, 379-381, 393-396, 425 creating, 388-389

initializing in Alienated Games program, 403-407 interface in Alienated Game program, 398 Charts property, of Workbook object, 380 ChartTitle object, 403 Chart Type worksheet, 384, 385 Check Box, 11

Check Box control, 56, 77, 216 in Poker Dice program, 80 property settings of, in Poker Dice program, 81 selected properties of, in Poker Dice program, 80 CheckFileFilters() sub procedure, 285 Child elements, 336, 353, 354 Chr() function, 106, 194, 323 Class definition, 156 Classes, 151, 156

Clear All button, Click() event of, 315 Clear All control, 300

ClearBoard() sub procedure, 142, 184, 186, 188

playing a hand of Blackjack and, 254, 255 ClearContents() method, 115 of Range object, 248, 315 Clear() method of Combo Box control, 226 of List Box control, 226, 232 ClearResults() public procedure, in Blackjack program, 248

Click() event procedure, 14, 19, 58, 50, 81, 126, 211, 212 of Calculate button, 272, 274 of Clear All button, 315

of cmdCalcStats Command Button control, 271 of Fill button, 323

in Math Game program, 134-135, 137 MultiPage control and, 224 Option Button control and, 216 of Print button, 324 Clock, in Math Game program, 140 Close() method, of Workbook object, 164, 165 Closing tags, for XML elements, 334 Clustered chart type, 391

cmdCalcStats Command Button control, Click() event of, 271 cmdCalculate, 231 cmdHit control, 260 cmd prefix, 13

Code, adding to event procedure of chart sheet, 393 Code window, 10

Collection objects, in VBA, 153-155 Colon (:)

avoiding in XML element names, 336 at end of line labels, 271 in new window captions, 162 Color cell, 15, 176-177 chart, 386

for puzzle area of worksheet, 325 shape, 431, 471 Shape objects, 442

of targets in Battlecell program, 194, 196 Color Changer program, 16 Color constants, VBA, 220 Colorful Stats program, 1 coding, 20-22 constructing, 17-22 designing, 18-19 requirements of, 17, 18 user interface for, 19 Colorlndex property, 176

of Interior object, 387, 406, 415 Column chart, 384, 385, 390, 391 ColumnCount property, 228 Column indexes, 109 Column property, of Range object, 195 Columns method, 171 Columns property, of Range object, 195 Column widths, adjusting in Excetris program, 460 ColumnWidths property, 228

Combo Box control, 224-225, 226, 266 on Blackjack form, 242 for new Math Game program, 350 playing a hand of Blackjack and, 253 selected properties of, 225 in Word Find program, 298

for worksheet design in Word Find program, 300 Command Button, 11, 12 Command Button control, 134 functionality of, 13-15 MouseDown() event procedure of, 58 Properties window of, 13 Comments, 20

Comparison operator(s) (=), 72

in VBA, 69-71 Compartmentalization, 29 Compiler, 5

ComputerFire() sub procedure, 191, 197 Computer viruses, 3 Concatenation, string, 47 Conditional operator (=), 103 Conditionals, branching and, 71-76 Conditional statements, with Do loop, 101 Constants, 26, 40, 47, 54 Const keyword, 40 Container controls, 222, 223 Container objects, 212 Controls, on worksheets, 11-12 Control Toolbox, 10, 11, 212 ConvertToRange() sub procedure, 410, 413 Copy() method, 121 CountCells() function, 320, 321 Count property, 164, 169, 248 of Range object, 185 of Shapes collection, 428 Crashes, 31, 39, 303, 326, 336

Create_Edit_Tests worksheet, 353, 364, 366, 367, 370 CreateRanAccessFile() sub procedure, 295 CreateSeqFile() procedure, 293

Ctrl-Alt-Break, program execution suspension and, 102 Custom data type definition, variable declaration vs., 234 Custom data types, 233

defining in VBA, 234-235 Custom dialog boxes, for quick statistics, 226-233 CustomerInfo, variable declaration, 235

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