[RESOLVED]Stopping Execution

[Jumpercables]

Is it possible to stop or step into the code of a macro as it is loading when you start word? In other words, when I start word the macro starts normally, but is it possible to step into the code as it begins to execute for the first time. So as soon as word starts I want it to start executing the macro but I also want to able to step through the code and debug it.

Thanks.

[RobDog888]

'Some of your macro code.
'
'
Stop
'More macro code.
'
'

Press F8 to contine debugging after the Stop code.

[Jumpercables]

Fantastic - Also under want reference name in VBA is the timer control?

[RobDog888]

Its not a control but rather a function call - Timer

From the help file...

Dim PauseTime, Start, Finish, TotalTime
If (MsgBox("Press Yes to pause for 5 seconds", 4)) = vbYes Then
    PauseTime = 5    ' Set duration.
    Start = Timer    ' Set start time.
    Do While Timer < Start + PauseTime
        DoEvents    ' Yield to other processes.
    Loop
    Finish = Timer    ' Set end time.
    TotalTime = Finish - Start    ' Calculate total time.
    MsgBox "Paused for " & TotalTime & " seconds"
Else
    End
End If

[dannymking]

You can also use the Sleep API to pause execution..

Private Declare Sub Sleep Lib "kernel32.dll" (ByVal dwMilliseconds As Long)
 
Sub temp()
  'code
  Sleep 1000 'pause for one second
  'more code
End Sub

[RobDog888]

Yes, but then your not immediatly thrown into debug mode and if you dont press Ctl+Break soon enough it will continue on processing.

[Jumpercables]

Hmm, Im not sure why this is so hard but I just want to have my form that states "Loading Blah Settings" show at the start of execution for 5 seconds then close. But it doesnt seem to pass off control once the form is loaded until I close the form.

[dannymking]

RD,

Your method takes two Message boxes which requires user intervention, if the programmer wants to pause execution for 5 seconds why would they want it to go into break mode straight after?

[RobDog888]

Your original question was how to stop code execution and enter into debug mode. Why dont you let us know what your really trying to do?

[RobDog888]

RD,

Your method takes two Message boxes which requires user intervention, if the programmer wants to pause execution for 5 seconds why would they want it to go into break mode straight after?

What are you talking about? He asked for stopping code to start debuging and then how to use a timer. Now hes changed things it will depend upon what he wants to do.

[Jumpercables]

Rob you answered my question prefectly. My other question about the timer is completely unrelated to the first one regarding the stop execution


My question about the timer was regarding something different that just came to mind while I was writing about the stop execution and figured since you moderators know everything about vb or vba I would kill two birds with one stone.

I wanted a timer to run to display a form saying "Loading Configuration Settings" then after about 5 seconds it would automatically close then continue with the rest of the code.

[RobDog888]

You can use either a loop with a timer or the sleep api. Both will work.

Dim iStop As Long
lStop = Timer + 5
frmSplash.Show
Do While Timer <= lStop
    DoEvents
Loop
UserForm1.Show