Cant run vba code independantly.
 

I have 6 modules.

one contains a subroutine called Sub Run_Agent()

if I am in any module, typing code and I want to test out the bit of
code I am working on, I usually (in other spreadsheets) just press the
play button and it goes from the top.

now it is just brining up a Macros window allowing me to choose the
macro to run.
the only thing in the list is Run_Agent.

does anyone know why this is?

regards,
Matt


--
matpj
------------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=514410

Cant run vba code independantly.
 

If the editing cursor is in a procedure then pressing F5 should run it.
However if this routine takes a parameter, it has to be called from another
sub that passes the argument.

--
Jim
"matpj" wrote in
message ...
|
| I have 6 modules.
|
| one contains a subroutine called Sub Run_Agent()
|
| if I am in any module, typing code and I want to test out the bit of
| code I am working on, I usually (in other spreadsheets) just press the
| play button and it goes from the top.
|
| now it is just brining up a Macros window allowing me to choose the
| macro to run.
| the only thing in the list is Run_Agent.
|
| does anyone know why this is?
|
| regards,
| Matt
|
|
| --
| matpj
| ------------------------------------------------------------------------
| matpj's Profile:
http://www.excelforum.com/member.php...o&userid=21076
| View this thread: http://www.excelforum.com/showthread...hreadid=514410
|