Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
InputBox vs. UserForm for Numerical Data Input | Excel Programming | |||
InputBox vs. UserForm for Numerical Data Input | Excel Programming | |||
Userform-allow numerical input? | Excel Programming | |||
Numerical Input via an inputbox method | Excel Programming | |||
Numerical Input via an inputbox method | Excel Programming |