| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pause code, wait for input, no input received, carry on with the code
Figured it out, just in case someone else needs it.
Sub testwait() UserForm1.Show vbModeless TimedDelay 9 MsgBox "wait over" End Sub Sub TimedDelay(sec As Single) Dim x As long x = Timer + sec Do While Timer < x nSec = Round(x - Timer, 0) UserForm1.Label3 = nSec DoEvents Loop End Sub Thanks John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Input Box Question with Code | Excel Programming | |||
| Input Box Code Please Help!! | Excel Programming | |||
| Code for Input Box | Excel Programming | |||
| pause for input during macro | Excel Programming | |||
| CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
Threaded Mode
