V

ValidateName() function procedure, 107, 108, 109 ValidatePt() function procedure, 423 Validation defined, 107 XML, 338 Validation module, 198 Validation procedures, 270

in Battlecell program, 198-202 Value integer element, in Blackjack program, 247, 249 Value property, 26, 40, 110, 120, 315 of Combo Box control, 226 of List Box control, 226, 230 of MultiPage control, 224, 229 Option Button control and, 216 RefEdit control and, 222 of Scroll Bar control, 387 Values in spreadsheet cell, 26 transposing, 115 Values property of SeriesCollection object, 405 of Series object, 389 Variable arrays, declaring, 235 Variable declaration custom data type definition vs., 234 placement of, 34 Variable length string variables, 37 Variables, 26, 27, 54

in Blackjack program, 247-248 declaring, 27-31 global, 31

in Math Game program, 134 memory locations of, 65 module level, 30 procedural level, 30 Variable scope, 30-31 Variant data types, 38-39

Variant keyword, 38

Variant variables, Battlecell program and, 186 VBA

collection objects in, 153-155 color constants in, 220 common data types in, 32 creating function procedures in, 65-66 defining custom data types in, 234-235 derived data types in, 233-237 designing forms with, 208-233 enumerated types defined in, 235-237 Excel application functions in, 68 file access modes with, 292 For/Next loops in, 104 installing and enabling, 3-4 I/O with, 40-42 logical operators with, 69-71 looping with, 100-106 mathematical operators in, 33 object-oriented programming and, 150-151 saving workbook from program in, 281 string functions, 44 XML and, 343-344 VBA debugger, 270 VBA file I/O methods, 282-295

FileDialogFilters collection object, 284-288 FileDialog object, 283-284

FileDialogSelectedltems collection object, 284-288 FileSystem object, 288 Open statement, 289 random access files, 294-295 sequential access files, 292-294 VBA help, accessing, 16-17

VBA IDE (Integrated Design Environment), 1, 5-10 accessing from Visual Basic toolbar, 6 in break mode, 274-275 components of, 5-10 getting help with, 15-17 Object Browser in, 155 VBA library, 156

VBA program, sound added to, 203-205 VBAProject library, 156 VBA shapes, 427-472

activating Shape objects, 435 OLEObjects collection, 436-438 ShapeRange collection object, 432-434 Shapes collection and Shape objects, 428-432 VbDayOfWeek enumerated type, 235 VB.net, 151 Verisign, 4

Version property, 215 vertical argument, 322 View Code icon, 13, 211 Viruses, 3

Visible property, 308

VisibleRange property, of Window object, 169, 185 Visual Basic (VB), for applications with Excel, 1-23 Visual Basic Editor icon, from Visual Basic toolbar, 5, 11 Visual Basic toolbar, 6, 10, 11-15

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