A colo(u)r chart for VBA

[kupe]

Anyone know a link please for a vba colo(u)r chart for using in access rather than the www?

 

[Rich]

What do you mean by vba colour chart? are you looking for the constants, vbRed etc?

 

[kupe]

Hi Rich

It would be handy to have a chart of the colours so at a glance I could see what colour and therefore number would suit each current job best. There are loads for dtp and www. But I've found it difficult to find one for vba. Can you help please? Cheers

 

[fuzzygeek]

Try creating one with the RGB Function

RGB(red, green, blue)
Returns a Long whole number representing an RGB color value.

Syntax

RGB(red, green, blue)

The RGB function syntax has these named arguments:

Part Description
red Required; Variant (Integer). Number in the range 0–255, inclusive, that represents the red component of the color.
green Required; Variant (Integer). Number in the range 0–255, inclusive, that represents the green component of the color.
blue Required; Variant (Integer). Number in the range 0–255, inclusive, that represents the blue component of the color.

or for 8 colors use the Color Constants (see help file)

or the QB Color function for 15 colors:

QBColor Function


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


Or try a variation of this using the QBCOLOR function:

http://support.microsoft.com/default.aspx?scid=kb;en-us;200527

 

[kupe]

Many thanks, fuzzygeek. I've been looking into this and found I'm using the wrong word in this context. I should have been asking for a color palette.

I've found two handy sites.

http://endprod.com/colors/

offers a palette of 500 colors and also a really handy color-picker in an Access db zipped up ready for download.

Another good example of colo(u)r is at

http://www.htmlprimer.com/colors.shtml

The hex # there can be copied and be taken to the color-picker and be translated into the vb #.

I've got your function, too, fuzzygeek. Very grateful. Cheers

 

[vicsar]

Many thanks, fuzzygeek. I've been looking into this and found I'm using the wrong word in this context. I should have been asking for a color palette.

I've found two handy sites.

endprod.com/colors/

offers a palette of 500 colors and also a really handy color-picker in an Access db zipped up ready for download.

Another good example of colo(u)r is at

htmlprimer.com/colors.shtml

The hex # there can be copied and be taken to the color-picker and be translated into the vb #.

I've got your function, too, fuzzygeek. Very grateful. Cheers

Thanks for this. endprod.com/colors/ just saved me