Funció Red

Returns the Red component of the specified composite color code.


Red (ColorNumber As Long)

Valor de retorn:


Paràmetres :

ColorNumber: Long integer expression that specifies any composite color code for which to return the Red component.


Under VBA compatibility mode (Option VBASupport 1), the function Red() is incompatible with VBA colors, when color from previous call to function RGB [VBA] is passed.

Codis d'error

5 La crida al procediment no és vàlida


The color picker dialog details the red, green and blue components of a composite color code, as well as its hexadecimal expression. Changing the color of text and selecting Custom color displays the color picker dialog.

Exemple :

Sub ExampleColor
Dim lVar As Long
    lVar = rgb(128,0,200)
    MsgBox "El color " & lVar & " consta de:" & Chr(13) &_
        "red= " & red(lVar) & Chr(13)&_
        "green= " & green(lVar) & Chr(13)&_
        "blue= " & blue(lVar) & Chr(13) , 64,"colors"
End Sub

Ens cal la vostra ajuda!