Hi, how do i set the 'error trappings' to be at the end, rather than as
I key into the function box.?
Eg.
Function DateConverter(XX)
Select Case XX
Case Is < 1000
MsgBox "blah blah", ,vbExclamation, "Too small"
End Select
Before i can even enter 5 digits, the message box will pop up once for
each digit i enter. say : 12345.. When i enter "1", box pops up once,
then again at 2, then 3...
Is it possible to get the msgbox to pop up ONLY at the end when i press
'ENTER' ??
--
silvest
------------------------------------------------------------------------
silvest's Profile:
http://www.excelforum.com/member.php...o&userid=14662
View this thread:
http://www.excelforum.com/showthread...hreadid=267318