H

Hard drive, 280 Height property, 160, 212, 241 of Application object, 168 Excetris program and, 460 List Box control and, 225 Help, VBA, 15-17

Hidden worksheets, 299, 303, 304, 309

Hide() method, forms hidden with, 214 HitOrMiss sub procedure, 191, 192 horizontal argument, 322 "Hot" shapes, 471 .html extension, 330

HTML (HyperText Markup Language), 330

IBM, 178

IDE (Integrated Development Environment), 1, 5 ID numbers, retrieving, 307 If/Elself decision structure, 422 If keyword, 71

If/Then decision structure, 143 If/Then/Else conditional statement, 56 If/Then/Else structure, 71-75, 86, 92, 97, 99, 194 If/Then statement, 100 Image control, 56, 77 on Blackjack form, 242 playing a hand of Blackjack and, 256, 257 in Poker Dice program, 78-80 property settings of, in Poker Dice program, 79 selected properties of, in Poker Dice program, 79 sizing in Blackjack game, 241 imageFile, 85 Image files, 280

ImageMapSwap() procedure, 423, 424 ImageMap worksheet, 400, 404, 406, 409, 414, 416, 418 imagePath, 85 Images, 427

loading, in Poker Dice program, 85 mapping, in Alienated Games program, 399-401 ImageSwap() function, 420, 423 Immediate window, 275-277 Import() method, URL argument of, 345 ImportXml() method, of XmlMap object, 346 INC constant, 322

IncrementStudentLevel() sub procedure, 372

Indentation, in code, 74

Indexes dollar signs in front of, 120 for objects, 154

returning Shape objects by, 428 returning single cell from Worksheet object and, 172 of Window objects, 162 Infinite loops, 102 Inheritance, 151 InitData() sub procedure, 404 InitDeck() sub procedure, 249 InitForm() sub procedure, 253

Initialize() event procedure, 212 of Blackjack form, 243 of UserForm object, 218, 219, 228 InitializeGame() sub procedure, 187 Initializing arrays, 112 InitSeriesImages() sub procedure, 406, 416 InitShape() sub procedure, 449 Input #, 294

InputBox() function, 52, 208, 215 collecting user input with, 40-41 validation with, 107-109 Input/output (I/O). See also I/O; File input and output Input validation, 45, 107-109, 144 with InputBox() function, 107-109 with spreadsheet cell, 109 InsertFunction tool, in Excel, 67, 68 InsertRowRange property, 349, 361, 371 InStr() function, 46 Integer data type, 28, 31, 32, 47, 235 Intelligence, programming into games, 177, 178 Interior object, 387

ColorIndex property of, 415 I/O (input/output)

in Colorful Stats program, 19 with VBA, 40-42 iPlayer argument, 259 IsExportable property, 346, 358 IsNothingOrStraight() function, 92 Item property, 164

of FileDialogSelectedItems object, 285 Iteration, 101, 177

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