Forum Discussion
How do we capture numeric input from an Excel Userform textbox?
We are using a textbox in an Excel Userform to request numeric input from the user. The two userform text boxes request numbers then used to set the width and height of a new checkbox form control o...
The code looks OK. See the attached demo workbook.
Have you defined CurrentCheckBox correctly?
Hello Hans, thank you so much again for the effort you went to in order to provide a sample using our exact userform control names. It was extremely easy to follow that way and helpful in confirming that the code we were using for resizing the checkbox should have been working fine. Your short example left us comfortable in redirecting our attention elsewhere looking for the problem. In our case, selecting the option did nothing, so we suspect there is some other mistake that is aborting the operation, before it is performed, without any error messages. Thank you again for taking the time to confirm the code was working fine.