I'll spare you the reason for why I'm trying to replicate part of the functionality of the built-in FontColorPicker (RibbonX customization).

Is there some system or environment property I can use in VBA to change the font color (cell contents) to the "active" font color?
If I've already used the FontColorPicker to apply say Red to cell contents, does Excel remember that color selection in a system property that I can make use of?

Looking to do the same for CellFillColorPicker.

Let me know if I'm not being clear enough with my request.

Thanks in advance,
Delain

cross-posted: http://www.eileenslounge.com/viewtopic.php?f=27&t=28225