Re: Get Color from Color Fill on Formatting toolbar
I still think you are off-track guys.
The OP said, and I quote, ... It will highlight the active cell upon its selction. I can set the code to whatever color I want, but I would like it to use the color set on the menu bar. Does anyone know how to do this? ...
In other words, he wants to pick up the fill colour on the menu bar, on some worksheet change event. By building a solution that uses a colour in some other cell, you are making it static when he asks for it dynamic. You might say, make the loading of that cell dynamic, but how? There is no event that traps a change in the colour in the Fill color button, so you can't.
The only solution that I can see is by using my function, or something like it, and call that from the event code. Not pretty, as it needs to iterate through the colours, and it assumes the palette will not be modified because that creates the horrible 'Color Scheme' tooltiptext, but it is dynamic, and can pick up the current colour regardless of that being changed.
That is my point, namely that RoyUk's suggestion was driving away from the answer, which has been added to. Adding this function to this alternative solution is pointless IMO, what does it gain to go via some routine that stores it in a cell rather than get it directly.