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

Ultimate Blackjack System

Ultimate Blackjack System

Discover the 100 Legal Secrets Las Vegas Professional Blackjack Gamblers Use to Make Literally Thousands of Dollars Every Week... I'll Teach You the Ultimate Step-by-Step Blackjack System, Casino's Don't Want You to Know About! That's Right, I'll show you step-by-step how to have the blackjack odds in your favor, guaranteed!

Get My Free Ebook


Post a comment