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