silvest

Enter the digits where?

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"silvest" wrote in message
...

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