Also,

how do i set the 'error trappings' to be at the end, rather than as
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 fo
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 pres
'ENTER' ?

--
silves
-----------------------------------------------------------------------
silvest's Profile: http://www.excelforum.com/member.php...fo&userid=1466
View this thread: http://www.excelforum.com/showthread.php?threadid=26728