[RESOLVED] Change label font color dynamically

Hello all,

I'm using VBA in Excell 2007 and I'm trying to change the color of a label's font depending on various circumstances. How do I do this dynamically? (i.e. I know how to do it from the editor, but that is not what I'm after.)

Thanks!

try like this

vb Code:

label1.forecolor =  ' long value or vb or xl colour constant, or rgb value

Oh. Now I feel silly. Thanks. :)