I am looking up 3 fields from text boxes on a userform.
The user enters the following values 0 - 100,000 and 50,000
In the code it will appear like this;
Sub Calc()
Z = "0"
i = "100,000"
rsb = "50,000"
If rsb > Z Then
If rsb < i Then
c = rsb
MsgBox c
End If
End If
End Sub
However the code does not recognise that 50,000 is smaller than 100,000 and skips that IF statement. (The text boxes have only numbers entered and then formatted to number ) If I remove the comma this issue is still there?
Is there a way around this?
If you copy this code into Excel and step through you will see my issue. Thank you
Bookmarks