Collabora Office 24.04 Help
Returns a Long integer color value consisting of red, green, and blue components.
RGB (Red, Green, Blue)
Long
red: Any integer expression that represents the red component (0-255) of the composite color.
green: Any integer expression that represents the green component (0-255) of the composite color.
blue: Any integer expression that represents the blue component (0-255) of the composite color.
The resulting Long value is calculated with the following formula:
Result = redĂ—65536 + greenĂ—256 + blue.
Under VBA compatibility mode (Option VBASupport 1), the Long value is calculated as
Result = red + greenĂ—256 + blueĂ—65536
See RGB Function [VBA]
The color picker dialog helps computing red, green and blue components of a composite color. Changing the color of text and selecting Custom color displays the color picker dialog.
Sub ExampleColor
Dim lVar As Long
lVar = rgb(128,0,200)
MsgBox "The color " & lVar & " consists of:" & Chr(13) &_
"red= " & red(lVar) & Chr(13)&_
"green= " & green(lVar) & Chr(13)&_
"blue= " & blue(lVar) & Chr(13) , 64,"colors"
End Sub