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, but I built an array that works well enough for me.
--
Neal Z


"Bob Phillips" wrote:

No, it is not readily accessible. I suggested this once before, not
infallible but it works (sort of).

CommandBars("Formatting").Controls("&Fill Color").TooltipText

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"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