I used the color detector downloaded from David McRitchie's website mentioned
in the last post.
It showed that the Button Face color is RGB(236,233,216). so I then run the
macro using this RGB setting, but the outcome cell color becomes
RGB(255,255,204) instead according to the same Color Detector used... Any
idea?

Thanks
Sam

"FSt1" wrote:

hi,
i don't have 2007. 2002 here. but the RGB equivilent to the button color is
RGB(220,220,220). how you would adjust that in 2007, i don't know.
in 2002, i adust the colors using the RGB scale.

regards
FSt1

"Sam Kuo" wrote:

Is there an equivalent "color index" for "system color" in VBA?

e.g. I'm thinking to color cells the same as a default button face color
(i.e. system color &H8000000F&) without having to create a shape or button,
but it doesn't seem to be possible from this very useful link I found in this
forum sometime ago...Is this right?

http://www.mvps.org/dmcritchie/excel/colors.htm

Sam