Dumb question on debugging (1 Viewer)

[Z34Lee]

I've searched and couldn't find an answer. This is going to sound stupid, but why can't I step-into and debug code unless it is in a Module?

 

[KeithG]

I don't understand your question. Where do you write code besides a module?

 

[Z34Lee]

I don't understand your question. Where do you write code besides a module?

When I'm working on code in within forms.

 

[Jimmy the Hand]

Event procedures don't start with F5 or F8. They are called on by the corresponding events. However, you can put breakpoints into the event procedures, too. Breakpoints will stop code execution, and then you can use F8 to step by step debugging. But you still have to click on the button, or change the textbox, or whatever it is that fires that particular event procedure.

 

[Z34Lee]

Thanks - I was hoping there was a way to run the code without actually triggering the event but I guess that is not possible.

 

[Jimmy the Hand]

Let's assume this is the event procedure of Button1

Private Sub Button1_Click()
   'code line 1
   'code line 2
   'code line 3
End Sub

You can break it into two like this

'This goes to a standard module
Sub Button1_Click_Core()
   'code line 1
   'code line 2
   'code line 3
End sub

'This stays on form's module
Private Sub Button1_Click()
   Button1_Click_Core
End Sub

If you put the core code of the event procedure into a standard code module, you can test/debug it independently of the event. Of course this path is not always passable, but sometimes it is.