NEED HELP: with running code

[Guest]

when I hit the run sub/userform F5 (green arrow button) in a form or control
code window I get a window titled: " Macro" asking for a macro name instead
of runing
the sub procedure? why is this window comming up, I don't want to run a
macro, just to step thru the code. If I type in the name of the sub
procedure in the "Macro" dialog window it says its already used?

 

[tina]

AFAIK, you can only use the "green arrow button" in a form or report module
when the procedure is already running and has been paused by a breakpoint -
then clicking the arrow will cause the procedure to resume running. suggest
you place a breakpoint in the first line of your procedure so it will pause
immediately, then you can step through it in the VBA Editor window.

btw, you *can* use the green arrow button to run procedures in a standard
module, without needing to insert a breakpoint.

hth

 

[Guest]

Thank you tina

AFAIK, you can only use the "green arrow button" in a form or report module
when the procedure is already running and has been paused by a breakpoint -
then clicking the arrow will cause the procedure to resume running. suggest
you place a breakpoint in the first line of your procedure so it will pause
immediately, then you can step through it in the VBA Editor window.

btw, you *can* use the green arrow button to run procedures in a standard
module, without needing to insert a breakpoint.

hth