VBA: change label forecolor (Integer)

[Xlacs]

Hello,

I'm wondering if I'm doing this correctly because my label caption forecolor remains "red" given my code below.
Hoping some could enlighten me with the below code. Thank you!!

If Val(Me.lbl1.caption) < 85 Then
Me.lbl1.forecolor = RGB(255,0,0,)
Else
Me.lbl1.forecolor = RGB(0,0,0)

End If

I also tried

If Val(Me.lbl1) < 85 Then
    Me.lbl1.forecolor = RGB(255,0,0,)
    Else
    Me.lbl1.forecolor = RGB(0,0,0)
    
    End If

However, the result is regardless the value, the forecolor remains red.

 

[Micron]

I moved the code I posted into an Excel userform and it still works. Unless you can make a file available for download I don't see what else I can suggest that I haven't already.

 

[Xlacs]

Hmm

I moved the code I posted into an Excel userform and it still works. Unless you can make a file available for download I don't see what else I can suggest that I haven't already.

Hmm. I guess the only option is to switch to textbox. anyway, Thanks a Lot Micron!!

 

[Micron]

You're welcome. Better luck next time!