Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
How to make a button VBA code reference other VBA code subroutines??? | Excel Programming | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming | |||
Independantly running code | Excel Programming |