Re: Macros Pause

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I understand how the step function work. I would like to watch the macro move
slower so I can film the steps to teach how a particular function works. This
would be similar to the SHOW Me function that some programs have. It shows
you each thing you click on and what it's doing as you go.
--
Gary Baker


"Nick Hodge" wrote:

> Gary
>
> F8 as outlined by Earl is debug mode, it steps a line at a time, allowing
> you to check what's happening, check variable values, etc. (I use this one
> mostly)
>
> A 'breakpoint' will literally stop the code at a certain line, again so you
> can check the state of the running code. From here you can either elect to
> step (F8) or run the remaining code. I tend to use breakpoints more in
> large code scenarios, when I now the first x lines work, to get to a
> problematical bit quickly, or most of the time in event code, so I can then
> step through (F8), after the event has fired. There is not a 'slow motion'
> setting if that is what you are asking...stop or step, that's about it.
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> nick_hodgeTAKETHISOUT@xxxxxxxxxxxxxxxxx
>
>
> "GWB Direct" <GWBDirect@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:61D6054A-CB4A-43E2-A3C5-AAD64093A41C@xxxxxxxxxxxxxxxx
> > Can I put a breakpoint in the code and watch it in excel after I hit the
> > button for the macro. I want to see visually what is happening but at a
> > slower pace. How do I put a breakpoint line in my macro and where do I put
> > it. Does it go before the With section or after the End With section.
> > --
> > Gary Baker
> >
> >
> > "Earl Kiosterud" wrote:
> >
> >> Gary,
> >>
> >> You can step it with F8 (in the VBE), and Alt-Tab back to Excel and watch
> >> stuff happen. Or put Excel and the VBE in windows (unmaximized). Or you
> >> can put a breakpoint (F9) on a line to stop it at selected places.
> >>
> >> --
> >> Earl Kiosterud
> >> mvpearl omitthisword at verizon period net
> >> -------------------------------------------
> >>
> >> "GWB Direct" <GWBDirect@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:0B41D13A-3AE4-4DF8-BEEA-9BDCD4F41D22@xxxxxxxxxxxxxxxx
> >> > Is there a line of code that I can add to my macros that would pause
> >> > between
> >> > each with or end with statment. I would like to view it slower than it
> >> > works
> >> > right now.
> >> > --
> >> > Gary Baker
> >>
> >>
> >>
>
>
>
.

Quantcast