Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
debug not working
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
debug not working
--Do you have any arguments to be passed for this sub routine?
--Make sure you are within a module.. --When you say you have other code executed..do you mean at the same time? is that in the same module or else where? If this post helps click Yes --------------- Jacob Skaria "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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
debug not working
No arguments.
I am within the module that I want to test. No, not at the same time, just mean that I have modules that work like they are supposed to. Event code, Module code. Can't use debug in any of it. Breakpoints do not stop execution. Some in the same module. "Jacob Skaria" wrote: --Do you have any arguments to be passed for this sub routine? --Make sure you are within a module.. --When you say you have other code executed..do you mean at the same time? is that in the same module or else where? If this post helps click Yes --------------- Jacob Skaria "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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
debug not working
The code I am trying to run is a deactivate event that closes a userform when
the active sheet is changed. Simple code, one line. Deactivate event does not run. The form is not closed. Debug.print does not display in the immediate window. Nothing happens when the sheet is changed. Everything is spelled correctly. Even if it wasn't I would get an error message and a highlight on the line that was wrong. I tried rebooting the computer. "Jacob Skaria" wrote: --Do you have any arguments to be passed for this sub routine? --Make sure you are within a module.. --When you say you have other code executed..do you mean at the same time? is that in the same module or else where? If this post helps click Yes --------------- Jacob Skaria "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP Debug | Excel Programming | |||
DeBug | Excel Discussion (Misc queries) | |||
Debug VBA | Excel Programming | |||
debug | Excel Programming | |||
debug help | Excel Programming |