Hi Everyone,
I have created a userform which limits the users choices for a ComboBox based on values they enter in multiple text boxes. The issue I am facing is that for example, that one of the textboxes has the user input the length of a product. If the limit for the option is for example 3000 (.Range("E" & A + 3).Value), if the user inputs 2800 (TextBox1.Text), then the code runs fine. However if the user inputs 500, it does not function. I believe this is caused by the fact that 5>3, as it only checks the first digit in the number. Is the anyway to stop this from happening. I have attached the code in question below. I have attempted simply changing the TextBox1.Text to .Value, however this seemed to cause more issues.
Please Login or Register to view this content.
Bookmarks