Annoying Pop up box in function
 

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 Wrote:
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



--
silvest
------------------------------------------------------------------------
silvest's Profile: http://www.excelforum.com/member.php...o&userid=14662
View this thread: http://www.excelforum.com/showthread...hreadid=267318

Annoying Pop up box in function
 

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..


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

"silvest" wrote in message
...

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 Wrote:
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



--
silvest
------------------------------------------------------------------------
silvest's Profile:
http://www.excelforum.com/member.php...o&userid=14662
View this thread: http://www.excelforum.com/showthread...hreadid=267318