Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default 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
|


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
split post code (zip code) out of cell that includes full address Concord Excel Discussion (Misc queries) 4 October 15th 09 06:59 PM
Drop Down/List w/Code and Definition, only code entered when selec Spiritdancer Excel Worksheet Functions 2 November 2nd 07 03:57 AM
How to make a button VBA code reference other VBA code subroutines??? gunman[_9_] Excel Programming 4 September 27th 05 01:01 AM
stubborn Excel crash when editing code with code, one solution Brian Murphy Excel Programming 0 February 20th 05 05:56 AM
Independantly running code Nath Excel Programming 3 August 4th 04 01:15 PM


All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"