I am creating a custom toolbar and want to add some of the default excel commandbarbuttons. I have added the "Font Colour" toolbar button. This button is a msoControlSplitButtonPopup type.
The question is, if I attach a macro to this button, how do I determine which value (or colour) was selected?
I would like to do something similar with the "Line Style" and "Line Colour" toolbar buttons.