Hi all,

My goal is to create a faster way to apply 'Fill Color' to a target cell. The 'Fill Color' will be dependent upon the color currently selected from the palette. For example, if I click in cell A1, select the color Green from 'Fill Color', then run a custom macro called 'FillColor1', I'd like cell A1 to be Green. However, if I then select the color Red from the palette in 'Fill Color', then rerun the macro, I would now like this cell to be Red.

I imagine this can be done using a macro whereby

Step1: Return the RGB color code for the color currently selected in the 'Fill Color' palette.
Step2: Apply the RGB color code to the cell's Interior property.

Does anyone know how to accomplish Step1? Any insight would be most appreciated. Thanks!