Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input to Form during Code Execution
While code is running, is there a way to have a form showing on the screen
that will allow input; that is, a check box that can be checked, or option button that can be selected, or a command button that can be used to set a parameter. Specifically, as the code executes and updates fields on the form, I'd like to be able to stop execution (using a command button), look at the data on the form, then resume execution (w/o using the Esc key). Is this possible? -- Bill @ UAMS |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input to Form during Code Execution
Here is Microsoft's example dor DoEvents: ' Create a variable to hold number of Visual Basic forms loaded ' and visible. Dim I, OpenForms For I = 1 To 150000 ' Start loop. If I Mod 1000 = 0 Then ' If loop has repeated 1000 times. OpenForms = DoEvents ' Yield to operating system. End If Next I ' Increment loop counter -- raypayett ----------------------------------------------------------------------- raypayette's Profile: http://www.excelforum.com/member.php...fo&userid=2956 View this thread: http://www.excelforum.com/showthread.php?threadid=57091 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input to Form during Code Execution
Thanks - I think that will work.
-- Bill @ UAMS "raypayette" wrote: Here is Microsoft's example dor DoEvents: ' Create a variable to hold number of Visual Basic forms loaded ' and visible. Dim I, OpenForms For I = 1 To 150000 ' Start loop. If I Mod 1000 = 0 Then ' If loop has repeated 1000 times. OpenForms = DoEvents ' Yield to operating system. End If Next I ' Increment loop counter. -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=570917 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Active Form during Execution | Excel Discussion (Misc queries) | |||
Form Updating during Execution | Excel Discussion (Misc queries) | |||
form stops execution | Excel Programming | |||
Pause code, wait for input, no input received, carry on with the code | Excel Programming | |||
Manual Input During Macro Execution | Excel Programming |