Hello Everyone,

I have a user form that I am building and I want to have the label change from "yes" to "no" depending on data in the cell next to it.

Select Case Inv_Val
Case "ASSET"
If Pay_Scan_dt = "" Then
With Pay_ico
.Forecolor- RGB(255, 0, 0)
.Caption = "Y"
End With
Else
With Pay_ico
.ForeColor = RGB (51, 255, 51)
.Caption = "N"
End With
End If
End Select

However, the Label just blanks out. Do I need to do something different in the Caption Properties to make these changes? Right now it's just blank.

Is there something I'm missing in the code?

Any help would be greatly appreciated!!

Thank You