View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default debug not working

Your top level subroutine or function probably has parameters or the
parameter list has an error. first try setting the Brek option in VBA as
follows from VBA menu

tools - Options - general - Break On Error

If you have a parameter list at your top level you can write a subrouting to
call your code. Define the parameter list to match you module.


Sub Test

Dim Param1 as Variant
Dim Param2 as Variant
Dim Param3 as Variant
Call Yourcode(param1, param2, param3)

end Sub



"JimRich" wrote:

I have some code that I am trying to fix and wanted to step through the code.
When i clicked on "Step Into" nothing happend. No other code is running.
The cursur is inside the sub routine. I have other code that is being
exicuted when i just run it but even with a breakpoint set it does not stop.
Is there a way to turn "Debug" back on?