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;
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?Please Login or Register to view this content.
Is there a way around this?
If you copy this code into Excel and step through you will see my issue. Thank you
Bookmarks