Annoying Pop up box in function

[silvest]

When i enter the digits into the function box. when it pops up with a
XX, and i have to key in the numbers

I've set the case to prompt if the number is below 1000.
and i want the prompt to come up only at the end after i press 'enter'.
Because when i want to key in 12345, I have to press '1' first, and
already the box pops up saying error (cos it's below 1000), and i have
to press okay, and then enter '2', and again the box pops up... then
'3', then '4' (which is okay since 1234 is above 1000), and finally 5,
and then i press 'enter' for the function to run.

 

[Dick Kusleika]

silvest

I'm not familiar with a "function box". What is that exactly?

One thing you could (depending on the above) is

If Len(XX) = 5 Then
Select Case XX
etc..