Changing Font Color of Dynamically created CheckBoxes

Hi Everyone,

Woo hoo - my first post. I must say this site is quite helpful. I normally search around to get answers to my (many many) questions. This one is different though - I have been unable to find what I'm looking for, (thus my post).

I am dynamically creating Check Boxes - with the following code:

Please Login or Register  to view this content.

As you can see I've tried a few things for the Font Color but am not coming right. As far as I can tell, VBA uses the current set Font Color. How can I change this???

Thanks all to all your help so far

To put it simple: you can't.

However, there IS a possible workaround if you hack the excel-file a bit.

I also suggest reading this for an alternative solution to your needs.