changing userform label control's color dynamically

edit - file test.xlsm attached

I'm trying to change label text colors dynamically in a user form based on the value of a checkbox.

Objects:

checkbox: chkTest
label: lblTest
textbox: txtTest

I set label's forecolor in the control's property to red (H000000FF) then run the following code:

Please Login or Register  to view this content.

On initialization of the form, the label's text is properly red.

But on chkbox click, the text turns black once and never changes again. The txtbox updates its value properly.

What am I doing wrong?

What I want to do is have a large section of one of my userforms to activate and change color if a particular checkbox is true. If False, then the controls are disabled and are greyed out.

Thanks!

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Something like this? Will change the checkbox forecolor

Please Login or Register  to view this content.

This will change the label

Please Login or Register  to view this content.

Replace your current code with the below one

Please Login or Register  to view this content.

doh. I tried the excel pallet color, color name, and color index. i didn't try rgb or the long number form of the colors. apparently either of those would have actually worked. Thanks guys, feeling stupid now ~_~ way too many hours in front of this screen apparently...