V
validation, checking input values via TestInput macro, 145-46
Value property OptionButton object, 229 Range object, 112-13 TextBox object, 232
variables for enabling Auto List feature, 66-67 vs. functions, 164 naming, 137 overview, 164 in recorded macros, 33 static, 290
Variant type, 66
View Code button, 196
viewing macros, 7-9
views, worksheet creating, 240-42 custom, 240-42 Summary view, 240-42
Visible property, 133
Visual Basic, 2. See also Visual Basic for Applications (VBA)
Visual Basic Editor. See also Object Browser eliminating macro lines, 12-13 Project Explorer button, 247 stepping through macros, 29-32 viewing macros, 7-9
Visual Basic for Applications (VBA). See also Visual Basic Editor Automation and, 2-3 dockable windows, 57 hiding, 4 relationship to Excel, 51
Visual Basic toolbar hiding, 4 Record Macro button, 5-6 Run Macro button, 29 showing, 4
volatile functions, 168 |