InputBox vs. UserForm for Numerical Data Input
 

Making progress:

Sharad,

I set-up 'Public Level As Integer' in a separate procedure, but not i
a separate module. Also, I inserted 'Unload Me' in the Private cod
for the text box.
Things are working better, but still not correct.
To get the integer 99 to pass thru to the main macro code, I have t
set the Value Property to "999" (as I mentioned before); then when th
Form pops up, I use the BS key to scrape one of the 9's off. <-- thi
is the only way.

Thanks again,
Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=27744