View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Neal Zimm Neal Zimm is offline
external usenet poster
 
Posts: 345
Default Font Color Index / Name Source

Thanks, their solutions are pretty close to mine. I built a string array
indexed by the colorindex number to return a string containing the name. I
filled in the "missing" numbers with a dummy color name called "Invalid".


to get the names i just recorded a macro click on each one of the colors in
the font palette.

good enough for me.

--
Neal Z


"Norman Jones" wrote:

Hi Neil,

See:

http://tinyurl.com/lm8ns


---
Regards,
Norman


"Neal Zimm" wrote in message
...
I have a need to display font color names by feeding the color index number
to "something". When I hold the mouse on a color in the palette the name
displays. Is there a source accessable by VBA or do I have to build a
procedure or function on my own?

Thanks.
--
Neal Z