Properties for Label Caption when using VB Script to change.

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

Hi there,

Try incorporating the following code into your UserForm CodeModule - it seems to work for me:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Unfortunately the label is still blank - Is there something I might have to put in the properties of the Caption? Should it be blank?

Hi again,

Sorry - I´m away from my computer until the end of next week

I´ll reply when I get back - sorry about the delay.

Best regards,

Greg M

Hi again,

Can you post your UserForm here so we can get a better idea of what might (not?) be happening?

Regards,

Greg M