Can't run vba in debug mode

[animas]

I have subs with arguments. I can't run the debug modes for these subs. When I remove the argument, debugging starts working.

What could be the issue?

 

[ColinKJ]

Hi animas,

Can you post an example of one of your subs so we can see what is going on.

ColinKJ

 

[animas]

Option Explicit

Sub TestMe1(ByVal tst As String)
    MsgBox "hello 1"
End Sub

Sub TestMe2()
    MsgBox "hello 2"
End Sub

F8 doesn't enter into Step Into mode for TestMe1 . But works fine with TestMe2. TestMe1 is also not shown in Macro list.

 

[ColinKJ]

Hi

The reason you can't debug this sub directly:

Sub TestMe1(ByVal tst As String)
    MsgBox "hello 1"
End Sub

Is because it is expecting to be called along with the variable "tst".

It is also why it doesn´t show in the macro list.

While it is expecting the variable "tst", it isn't being used in the routine.

Do you know where in your codes you are calling the routine "TestMe1"

ColinKJ

 

[animas]

Ya. If i step into from the calling sub, it works ok.
But as far as I remember I was able to step into with arguments sub until today. Are you sure that is not allowed?

 

[ColinKJ]

Ya, absolutely sure, I just tried it.

ColinKJ

 

[animas]

Thanks.

 

[Zack Barresse]

You would need to call your routine (with variables which need passing) either by calling it from another sub/function or the immediate window. Probably one of the easiest ways to then step through it is to put a breakpoint on the first line of your sub (F9 is the shortcut key to add a breakpoint to a line, or click on the left of the margin).

 

[animas]

I put a call procedure sub1 just above my sub2 and steping into sub1 making it ez.