Variables

The following Visual Basic commands have been tested with IDEA v9 and appear to be functioning properly. I have added some examples where possible on their use.

Boolean

A Boolean variable can hold a True/False value. Boolean variables (and properties) are used frequently in VBA programming to hold data that can be on/off, yes/no, and so on. When you declare a Boolean variable, it is automatically initialized to False.

Byte

Name: Byte

Type: Integer - Numbers with no fractional part

Range: 0 to 255

Currency

Name: Currency

Type: Floating Point

Range: -9.22 × 1011 to 9.22 × 1011 approximately

Precision: 4 digits

Date

The term date is used to refer to both dates and times.  Dates are represented numerically as floating-point numbers. The integer part of the number represents the date as the number of days since December 30, 1899 (with negative numbers for prior dates), and the fractional part of the number represents the time of day as a fraction of the 24-hour day.

Double

Name: Double

Type: Floating Point

Rangle: -1.79 × 10308 to 1.79 × 10308 approximately

Precision: 14 digits

Dynamic Arrays

A dynamic array does not have a fixed size. It can be enlarged or shrunk as needed by code during program execution. A dynamic array is declared by using empty parentheses in the Dim statement.

Before using the array, you must set its size using the ReDim statement.

Floating point

String variables are used to hold text data.  A fixed-length string can be declared to contain anywhere from 1 to about 64,000 characters.  To declare a fixed-length string, use the String keyword followed by the * (asterisk) symbol and the desired size.

Integer

Name: Integer

Type: Integer

Range: -32,768 to 32767

Integers

Numbers with no fractional part.

Long

Name: Long

Type: Integer

Range: -2,147,483,648 to 2,147,483,647

Pages