Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
InputBox vs. UserForm for Numerical Data Input
Sharad, Thanks again. I will respond to your most recent post first. inserted the two lines and the UserForm works exactly as I wanted. Now, the other post. When I opened your .jpg file, it was somewha distorted, but I think I get the idea. And that idea is the same a what you had recommended a couple of posts ago (and I responded to yo that I had done so). This is what I have: Public Level As Integer __________________________________________________ _______________ Sub Macro1() CODING .... Call Macro2 End Sub __________________________________________________ _______________ Sub Macro2() CODING .... Call Macro3 End Sub __________________________________________________ _______________ Sub Macro3() CODING .... End Sub ALL of the above is in Module 1. The current UserForm that we have been discussing is Macro3 -- whe testing the UserForm, I have been running Macro3 only. I may have just answered my own question. Since I have been running only Macro3 (using a saved WB that wa created after running only Macro1 and Macro2 -- and, I believe, befor creating 'Public Level As Integer' at the top of Module 1), perhap this is causing the "one cycle" delay. I will not have access to th "before Macro1" WB until tomorrow -- will test then and advise you, bu I am sure that Macro3 will work without the "one cycle" delay. 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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
InputBox vs. UserForm for Numerical Data Input | Excel Programming | |||
InputBox vs. UserForm for Numerical Data Input | Excel Programming | |||
InputBox vs. UserForm for Numerical Data Input | Excel Programming | |||
InputBox vs. UserForm for Numerical Data Input | Excel Programming | |||
InputBox vs. UserForm for Numerical Data Input | Excel Programming |