if statement for Percent

[Av8tordude]

I have this if/then statement that doesn't run correctly. lbSL is a label on a userform that displays 5.5% and it should execute the first part of the if/then statement. However, it executes the second part of the if/then statement. My guess the code does not recognize the lbSl.Caption as a value. Can someone assist thank you.


lbSL.Caption = 5.5%

    If lbSL.caption < "15%" Then
        lbRatio = "Ok"
        lbRatio.ForeColor = vbBlue
    Else
        lbRatio = "Caution"
        lbRatio.ForeColor = vbRed
    End If

 

[steve the fish]

Try using evaluate and use 0.15 for the percentage. I believe that will work:

If Evaluate(lbSL.caption) < 0.15 Then

 

[Av8tordude]

Works great. Can you explain why the code does not recognize the value? Thank you.