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.
Submitted by Brian Element on Sat, 07/14/2012 - 19:49
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.
Submitted by Brian Element on Sat, 07/14/2012 - 19:50
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.
Submitted by Brian Element on Sat, 07/14/2012 - 19:39
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.
Submitted by Brian Element on Sat, 07/14/2012 - 19:51
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.