Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
InputBox vs. UserForm for Numerical Data Input | Excel Programming | |||
InputBox vs. UserForm for Numerical Data Input | Excel Programming | |||
InputBox vs. UserForm for Numerical Data Input | Excel Programming | |||
InputBox vs. UserForm for Numerical Data Input | Excel Programming | |||
InputBox vs. UserForm for Numerical Data Input | Excel Programming |