InputBox vs. UserForm for Numerical Data Input
 

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

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=27744

InputBox vs. UserForm for Numerical Data Input
 

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

"Chuckles123" wrote in message
...

Two additional things I was thinking about:

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

Chuckles123


--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile:
http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=277448