VB Language

Single

Brian Element

Sat, 07/14/2012 - 19:52

Name: Single

Type: Floating point

Range: -3.4 × 10³⁸ to 3.4 × 10³⁸ approximately

Precision: 6 digits

Read more about Single
Log in or register to post comments

Sqr()

Brian Element

Tue, 08/28/2012 - 08:08

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

Read more about Sqr()
Log in or register to post comments

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

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.

Read more about String
Log in or register to post comments

Tan()

Brian Element

Tue, 08/28/2012 - 08:10

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

Read more about Tan()
Log in or register to post comments

The Select Case Statement

Brian Element

Sat, 07/14/2012 - 19:47

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

Read more about The Select Case Statement
Log in or register to post comments

Time()

Brian Element

Sat, 07/14/2012 - 19:43

Returns the current system time (no date information).

Read more about Time()
Log in or register to post comments

TimeSerial

Brian Element

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