Hi I'm creating a userform, which requires a user to provide a value within a specified numerical range depending on the material selected.
For example, if the material selected is "RIVETED STEEL", the value must be between 0.9144 and 9.144. Otherwise, a message box will appear to remind him that the value is out of range.
This is the work flow:
1) In a userform (LeD), user will select a material in a combobox (cbpm)
2) A window (ARC) will appear to prompt the user to provide a number in a textbox (txtarc).
3) If the numberis valid, it will be sent to an excel sheet after the user has clicked on a command button (arcadd)
4) If not, the same message box will reappear to remind user to provide a valid number
When I provide a valid number, I was still prompted with the message box.
Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks