Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
InputBox vs. UserForm for Numerical Data Input Chuckles123[_52_] Excel Programming 1 November 13th 04 07:01 AM
InputBox vs. UserForm for Numerical Data Input Chuckles123[_51_] Excel Programming 3 November 12th 04 08:37 AM
Userform-allow numerical input? waveracerr[_20_] Excel Programming 2 September 14th 04 08:11 PM
Numerical Input via an inputbox method Tom Ogilvy Excel Programming 0 August 16th 04 07:33 PM
Numerical Input via an inputbox method Bob Phillips[_6_] Excel Programming 0 August 16th 04 07:30 PM


All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"