VB Language

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.

Single

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:52

Name: Single

Type: Floating point

Range: -3.4 × 1038 to 3.4 × 1038 approximately

Precision: 6 digits

Sqr()

Brian Element's picture
Submitted by Brian Element on Tue, 08/28/2012 - 08:08

This function returns the square root of a number.  The return value is a double type.

Static Arrays

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:40

A static array has a fixed size or number of elements. You specify the array size when you declare it, and the size cannot change during program execution.  The size will be one more than n because VBA array indexes start by default at 0.

You can use an integer variable or constant as the index.

String

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:50

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.

Tan()

Brian Element's picture
Submitted by Brian Element on Tue, 08/28/2012 - 08:10

This function returns the tangent of an angle.  The return value is of type double.

The Select Case Statement

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:47

The Select Case statement lets your program make multiple choices based on the value of a single expression.

Time()

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:43

Returns the current system time (no date information).

TimeSerial

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:43

Use the TimeSerial function to create time values for type Date variables.

For TimeSerial, the values are normally in the range 0 to 23 for hours, and 0 to 59 for minutes and seconds. Larger values wrap to the next larger unit; therefore, a seconds value of 90 corresponds to one minute and 30 seconds

TimeValue()

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:43

Use the TimeValue function to create time values for type Date variables.

TypeName()

Brian Element's picture
Submitted by Brian Element on Tue, 08/28/2012 - 06:55

Need to add explanation.

Pages