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.

Goto Statement

The Goto statement instructs program execution to go to the specified location in the code.

A label itself has no effect on program operation—it serves only as the target of a Goto.

Hour()

Hour(date) Returns a value 0–23 representing the hour of the day

If...Then Statement

The If...Then statement, or If statement for short, is used in a program to execute a block of code if a specified logical condition is True.  If condition is True, the statements in the block (indicated by block1) are executed. If condition is False, they are not executed.

Int()

The Fix() and Int() functions both remove the fractional part of a number and returns the restulting integer.  The difference between the two is that if a number is negative Int() returns the first negative integer less than or equal to the number while Fix returns the first negative integer greater than or equal to the numer.

Integer

Name: Integer

Type: Integer

Range: -32,768 to 32767

Integers

Numbers with no fractional part.

Log()

This function calculates the natural log (base e) of the specified number.  The value that is returned is of a type double.  To see an example of how to calculate the log of a base 10 see the snippets section.

Logical Operators

VBA has six logical operators:

Long

Name: Long

Type: Integer

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

Minute()

Minute(date) Returns a value 0–59 representing the minute of the hour

Pages