Hi everyone,
I've got a UserForm with a bunch of TextBoxes on which the user is inputting numerical values into.
After any entry a macro is rounding the value to the nearest multiple of 25 using application.worksheetfunctionceiling/floor functionality.
I've got a problem that as the value in the textbox approaches 33,000 I get an overflow error message. (I'm presuming at 32 bits)
Is there an easy way to avoid this?
Thanks,
Ian