QBColor Function
This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.
Returns a Long representing the RGB color code corresponding to the specified color number.
Syntax
QBColor(color)
The required color argument is a whole number in the range 0–15.
Settings
The color argument has these settings:
Number |
Color |
Number |
Color |
|---|---|---|---|
0 |
Black |
8 |
Gray |
1 |
Blue |
9 |
Light Blue |
2 |
Green |
10 |
Light Green |
3 |
Cyan |
11 |
Light Cyan |
4 |
Red |
12 |
Light Red |
5 |
Magenta |
13 |
Light Magenta |
6 |
Yellow |
14 |
Light Yellow |
7 |
White |
15 |
Bright White |
Remarks
The color argument represents color values used by earlier versions of Basic (such as Microsoft Visual Basic for MS-DOS and the Basic Compiler). Starting with the least-significant byte, the returned value specifies the red, green, and blue values used to set the appropriate color in the RGB system used by Visual Basic for Applications.
Example
This example uses the QBColor function to change the BackColor property of the form passed in as MyForm to the color indicated by ColorCode. QBColor accepts integer values between 0 and 15.
Sub ChangeBackColor (ColorCode As Integer, MyForm As Form)
MyForm.BackColor = QBColor(ColorCode)
End Sub