Hi,

Is there more than the standard 56 colours available to use within
excel if programmed into VB? and secondly where can i find a index
matrix, as i dont know the code for each colour? I have searched the
internet with out success!

Thanks
Dave


--
DHallam
------------------------------------------------------------------------
DHallam's Profile: http://www.excelforum.com/member.php...o&userid=25253
View this thread: http://www.excelforum.com/showthread...hreadid=547543

You can change any of the predefined colors, but you cannot use more than 56
different colors at a time.

HTH
--
AP

"DHallam" a écrit
dans le message de news:
...

Hi,

Is there more than the standard 56 colours available to use within
excel if programmed into VB? and secondly where can i find a index
matrix, as i dont know the code for each colour? I have searched the
internet with out success!

Thanks
Dave


--
DHallam
------------------------------------------------------------------------
DHallam's Profile:
http://www.excelforum.com/member.php...o&userid=25253
View this thread: http://www.excelforum.com/showthread...hreadid=547543

Colour matrix attached.


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4835 |
+-------------------------------------------------------------------+

--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=547543

--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

1 Black
2 White
3 Red
4 Bright Green
5 Blue
6 Yellow
7 Pink
8 Turquoise
9 Dark Red
10 Green
11 Dark Blue
12 Dark Yellow
13 Violet
14 Teal
15 Gray-25%
16 Gray-50%
17 Periwinkle
18 Plum
19 Ivory
20 Light Turquoise
21 Dark Purple
22 Coral
23 Ocean Blue
24 Ice Blue
25 Dark Blue
26 Pink
27 Yellow
28 Turquoise
29 Violet
30 Dark Red
31 Teal
32 Blue
33 Sky Blue
34 Light Turquoise
35 Light Green
36 Light Yellow
37 Pale Blue
38 Rose
39 Lavender
40 Tan
41 Light Blue
42 Aqua
43 Lime
44 Gold
45 Light Orange
46 Orange
47 Blue-Gray
48 Gray-40%
49 Dark Teal
50 Sea Green
51 Dark Green
52 Olive Green
53 Brown
54 Plum
55 Indigo
56 Gray-80%
'-------------------

"DHallam"
wrote in message
Hi,
Is there more than the standard 56 colours available to use within
excel if programmed into VB? and secondly where can i find a index
matrix, as i dont know the code for each colour? I have searched the
internet with out success!
Thanks
Dave