InputBox vs. UserForm for Numerical Data Input

C

Chuckles123

Two additional things I was thinking about:

When an error message pops up and the user clears it, is it possibl
for "focus" to return to the textbox? Also, is it possible for th
previous value to be cleared?

Chuckles12
 
S

Sharad Naik

In your "Private Sub cmdCUT_OFF_LEVEL_Click()" Procedure,
After the MsgBox, (above, Exit Sub) add following two lines.
inptCUT_OFF_LEVEL.Value = ""
inptCUT_OFF_LEVEL.SetFocus

Sharad
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

InputBox vs. UserForm for Numerical Data Input 3
InputBox vs. UserForm for Numerical Data Input 1
InputBox vs. UserForm for Numerical Data Input 1
Data validation using TextBox in UserForm 3
Data validation in Userform sub 1
InputBox Date Value 7
Number validation in Textbox using UserForm 1
Create Userform from Worksheet 8

Top