Hi

i'm really confused ... would you like to zip up your workbook (containing
the userform & the sheet it supposed to work with etc) and email it direct
to me (julied_ng @ hcts dot net dot au) and i'll have a look at it for you.

Cheers
JulieD

"Chuckles123" wrote in message
...

In the absence of any responses, I am proceeding with my attempt.
I have about a 40-word message that the user needs to see when
inputting the 2- or 3-digit number; this message is definitely too big
for an InputBox.

Hence, the idea of an UserForm. I have finished with the design of my
Form and it looks great; unfortunately, it doesn't work -- HELP!

In my Form, I have a Label button for my long message and a text box
for user input of the 2- or 3-digit number.

When I step-thru the macro and the Form opens -- there is a blinking
vertical cursor adjacent to the right edge of the Value Property (in my
case, "100", which is a string); keying the Enter key has zero impact;
if I key any single digit, it is appended to the right edge of 100 and
the macro proceeds to inspect the code for the text box; keying
'backspace' removes the rightmost digit from 100 and the macro proceeds
with inspecting the code for the text box.

I have changed my error testing from "2 or 3 digits?" to calculating
MIN and MAX values in the main macro (these are variables) and then
testing the user input level, after using "Val" to convert to a number,
against this range. I pasted the error testing into the code for the
text box; however, I am not able to get the Form to reappear. Even
when setting the Value Property at "999" and deleting the right-most
"9", I can get a MsgBox to display the number, but I am not bringing
that value back to the main macro.

As I said before, HELP.
Chuckles123


--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile:
http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=277448