Term
|
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
|
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
|
Definition
| Use the _____ numeric data type to store monetary values from \'96922,337,203,477.5808 to 922,337,203,685,477.5807.\ |
|
|
Term
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
Definition
| The loop goes up/down a step size from i1 to in\ |
|
|
Term
|
Definition
| the ______ loop runs through every object within a set of objects.\ |
|
|
Term
|
Definition
| The _____ repeatedly executes a section of code while a specified condition continues to evaluate to True.\ |
|
|
Term
|
Definition
| Look at page 117-118 in book\ |
|
|
Term
|
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
|
Definition
| A ____ is a template or blueprint for an object and describes the data stored\ |
|
|
Term
|
Definition
| A ______ is a structure containing data and methods that manipulate the data.\ |
|
|
Term
|
Definition
| Rules of a programming language\ |
|
|
Term
|
Definition
|
|
Term
| Project Explorer, Properties Window, Procedure, Immediate Window |
|
Definition
| common windows on VBA Editor?\ |
|
|
Term
|
Definition
| x(4) = 3; example of an _______. Here, the fourth space in x is = to 4.} |
|
|
