Change label caption's font color based on value in another textbox

Hi Forum,

I had some help in here previously with finding a way to change a label caption based on a date value in a corresponding textbox... Now, I'm hoping to receive some help to change the captions font color. Below is the code I'm currently using to change the label's caption:

Please Login or Register  to view this content.

What I would like is for the caption's font to appear green if it meets criteria for the "Case True" statement in the above select case. Any help? Thanks!

The usual approach is do the task with record macro running and see what it generates. I tried that (XL2007) and it recorded everything [I]except the colour change. That may not mean it cannot be done but it renders this post less valuable than I had hoped!

hi baker,

Thanks for the reply. It seems like you should be able to do using

Please Login or Register  to view this content.

within the Select Case statement...but I haven't been able to make it work. Anybody else have any suggestions? Thanks!

Originally Posted by XeRo Solus

Edit: Just found the pallet... will work on code.

Hi Solus,

Thanks for the reply. Can you show me the code you believe will work? I've tried the following and it doesn't seem to work... (bold added for emphasis)

Please Login or Register  to view this content.

Originally Posted by XeRo Solus

Please see post #5

Thanks Solus! I think I was typing my reply before I saw the edit to this post.... It is working! Thanks!!