RGB Function [VBA]

Returns a Long integer colour value consisting of red, green, and blue components, according to VBA colour formula.

This constant, function or object is enabled with the statement Option VBASupport 1 placed before the executable program code in a module.

Syntax:

RGB (Red, Green, Blue)

Return value:

Long

Parameters:

red: Any integer expression that represents the red component (0-255) of the composite colour.

green: Any integer expression that represents the green component (0-255) of the composite colour.

blue: Any integer expression that represents the blue component (0-255) of the composite colour.

Because of the VBA compatibility mode (Option VBASupport 1), the Long value is calculated as

Result = red + green×256 + blue×65536.

Error codes:

5 Invalid procedure call

Example:

Option VBASupport 1
Sub ExampleRGBVBA
Dim lVar As Long
    lVar = rgb(128,0,200)
    Print lVar; ' returns 13107328
End Sub