F8 step into doesnt work

[bob733]

I have a vba macro attached to a worksheet. When I enter debug mode, F8 will not start stepping into the macro. Nothing happens at all.

Probably something easy but I cant figure it out.

Thanks in advance.

 

[Norie]

How exactly are you entering debug mode?

Where has the code been stopped/paused?

 

[bob733]

Click Developer, View Code, Depress f8
Nothing happens

 

[Norie]

This might be a stupid question, but where's the cursor when you do that?

 

[bob733]

clicked on the first line

 

[shg]

What is the signature of the procedure you're trying to step into?

It must be a Sub (not a Function), and it cannot have any arguments.

 

[bob733]

Private Sub Worksheet_Change(ByVal Target As Range)

 

[Norie]

First line of the Sub?

 

[Norie]

Bob

You can't run that with F8.

Try putting a breakpoint on the first line with F9.

Then goto the worksheet and enter something in a cell.

The change event will be triggered and you can then step through it.

 

[bob733]

Great call! I never would have got that. Thanks. I may come back when the code itself doesnt work! haha

Thanks ever so much.

Bob