PDA

View Full Version : [SOLVED] How Does the RGB (Color) Fctn Work?



Cyberdude
04-08-2005, 07:08 PM
Is there a way that I can use VBA statements to fetch the RGB color component (red, blue, green) values? I found a few terse writeups in help, but they didn't really help. I was reading about the RGB function, and it claims to return the color value as though it were a single value. I thought maybe that value might be the product of the 3 component values, and I didn't seem to be that far off, but ...:dunno

Zack Barresse
04-09-2005, 11:44 AM
This snippet from Chip Pearson's (http://www.cpearson.com/excel/colors.htm#RGB) site may be helpful. It describes what you are asking for I believe.


HTH

Cyberdude
04-09-2005, 03:49 PM
Yesssss, firefytr. that's exactly what I want! Thanx a mil.