Hi Jeff,
Fantastic! not only does that code work, I was able to modify it to also be used on the Hub Thk Textbox where the acceptable limits in the parameters sheet can change based on the size and SDR combinations picked in the Size and SDR combo boxes.
I am however having issues with modifying the same bit of code for the OAL Textbox and I'm not sure why, I would think it should be very similar to the above code with some changes like to the below.
Edit:sorry, got it all working thus far. again, thanks Jeff for all the help with this. I'm sure you'll hear from me again with some other things as I am learning as I go. Big big thanks.
Hopefully the more completed parameters worksheet on the attached file gives a better idea of the limits I'm trying to display in the userform if the value entered is outside the set parameters.
Thanks,
Jon
Bookmarks