# Shared Flashcard Set

## Details

COMP VBA
COMP VBA
23
Computer Science
10/28/2010

Term
 \f0\fs24 \cf0 Boolean
Definition
 Use the _________ data type to store logical data that contains only two values: on and off, true and false, yes and no, and so on. The keywords True and False are predefined constants and are interchangeable with the values \'961 and 0, respectively.\
Term
 Byte
Definition
 ____ is VBA's smallest numeric data type and holds a numeric value from 0 to 255. This data type doesn't include any negative values. If you attempt to assign one, VBA returns an error.\
Term
 Currency
Definition
 Use the _____ numeric data type to store monetary values from \'96922,337,203,477.5808 to 922,337,203,685,477.5807.\
Term
 Date
Definition
 The ____ data type stores a specially formatted numeric value that represents both the date and time. You don't have to store both the date and time value. The ____ data type accepts either the date or the time, or both. Possible values range from January 1, 100 to December 31, 9999.\
Term
 Decimal
Definition
 he _____ data type is a subtype of Variant and not a truly separate data type all its own, accommodating values from \'9679,228,162,514,264,337,593,543,950,335 to 79,228,162,514,264,337,593,543,950,335 if the value contains no decimal places. The data type maintains precision up to 28 decimal places with values from \'967.9228162514264337593543950335 to 7.9228162514264337593543950335.\
Term
 Double
Definition
 Use the _____ data type to store precision floating point numbers from \'961.79769313486232E308 to \'964.94065645841247E-324 or 1.79769313486232E308 to 4.94065645841247E-324.\
Term
 Integer
Definition
 This is probably the most common data type in use, besides String. Use this data type to store only whole numbers that range from \'9632,768 to 32,767.\
Term
 Long
Definition
 The ____ data type is also an Integer data type storing only whole numbers, but the range is much larger than the traditional Integer data type. Use ____ to store values from \'962,147,483,648 to 2,147,483,647.\
Term
 Single
Definition
 The ____ data type stores precision numbers\'97numbers with decimal places or fractional numbers. The data type is similar to Double, but the range is smaller. Use this data type to store values from \'963402823E38 to \'961.401298E\'9645 or from 1.401298E\'9645 to 3.402823E38.\
Term
 String
Definition
 ____ is another very common data type; it stores values or numbers, but treats them as text. There are two varieties: fixed and variable. A fixed ____ can handle from 1 to 65,400 characters.\
Term
 Variant
Definition
 The ____ data type stores numeric and non-numeric values. This data type is the most flexible of the bunch because it stores very large values of almost any type (matches the Double numeric data type). Use it only when you're uncertain of the data's type or when you're accommodating foreign data and you're not sure of the data type's specifications.\
Term
 For ... Next
Definition
 The ______ loop sets the variable i to have the values 1, 2, 3, ..., 10, and for each of these values, runs through the VBA code inside the loop.\
Term
 Step
Definition
 The loop goes up/down a step size from i1 to in\
Term
 For Each
Definition
 the ______ loop runs through every object within a set of objects.\
Term
 Do While loop
Definition
 The _____ repeatedly executes a section of code while a specified condition continues to evaluate to True.\
Term
 Select Case
Definition
 Look at page 117-118 in book\
Term
 Range
Definition
 A ______ object can be a single cell, a rectangular block of cells, or the union of many rectangular blocks (a non-contiguous range). A _______ object is contained within a Worksheet object.\
Term
 class
Definition
 A ____ is a template or blueprint for an object and describes the data stored\
Term
 Object
Definition
 A ______ is a structure containing data and methods that manipulate the data.\
Term
 Syntax
Definition
 Rules of a programming language\
Term
 Object
Definition
 VBA is ____-Based\
Term
 Project Explorer, Properties Window, Procedure, Immediate Window
Definition
 common windows on VBA Editor?\
Term
 Array
Definition
 x(4) = 3; example of an _______. Here, the fourth space in x is = to 4.}
Supporting users have an ad free experience!