W

Watch Expression, 278 Watch type, selecting, 278 Watch window, 277-279 Wave Form Audio (.wav file), 203

for Blackjack game, 242 Wav files, playing via Windows API, 204-205 Web pages, 330

Weekdays enumerated type, 236

what argument, outputting results of hand to Blackjack worksheet and, 265 While keyword, 101 Width property, 59, 160, 212, 241 of Application object, 168 Excetris program and, 460 Window object, 155, 161-169, 205 WindowResize() event, of Workbook object, 169, 182, 183, 185

Windows API (Application Programming Interface),

203-205 WindowState property, 168 With/End With structure, 173-175, 205, 388 Wizards, 220

Word Find program, 269, 296-326 designing, 298-301 form design, 298-300 requirements for, 296-298 worksheet design, 300-301 writing code for, 301-326 writing code for Userform module, 302-314 writing code for Worksheet module, 315-326 Wordfind worksheets, 269, 270 Word search puzzles, 296, 324 WordToList() sub procedure, 323 WordWrap property, 299

Workbook object, 150, 153, 154, 161-169, 162, 175, 205, 279 Charts property of, 380 Close() method of, 164, 165 object module for, in Battlecell program, 181

Open() event of, 167 SaveAs() method of, 281, 283, 343 viewing worksheets property of, 158 WindowResize() event of, 169 Workbook_Open event procedure, 170 Workbooks, 8, 9 centering, 166 closing, 165-166 opening, 281 saving, 15, 281-282 Workbooks collection object, 163 Workbooks objects, 155 Workbook windows, resizing, 168, 169 Worksheet_Activate() event procedure, 170 Worksheet cells, programming formulas into, 120-123 WorksheetFunction property, 161 Worksheet interface, for Battlecell program, 180 Worksheet module, writing code for, 315-326 Worksheet object, 150, 153, 159, 162, 169-170, 174, 175, 205, 386 Cells property of, 172 Change() event of, 368 object module for, in Battlecell program, 181 PrintOut() method of, 325 Select() method of, 170 Shapes property of, 428 Worksheets altering properties of, in Excel using VBA, 7-9 for Blackjack game, 242, 243 controls on, 11-12 drawing layers in, 428 embedded chart on, 381 hidden, 299, 303, 304, 309 for Magic Squares, 34-37 for Math Game program 125 for new Math Game program, 350, 351 saving as text files, 283 saving as XML data, 343 saving to XML files, 341 shapes added to, 429 triggering Change() event of, 143 for Word Find program, 269, 270, 300-301 word search puzzle created on, 300 Worksheets collection object, 379 Worksheets objects, 155 World Wide Web, 151, 329 World Wide Web Consortium, 332 Write #, 293, 294

WriteRemainingProblems() sub procedure, 369 WriteWord() sub procedure, 318, 322

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