Debugging code in a form

  • Thread starter Thread starter Jim Pockmire
  • Start date Start date
You can just type the name of the sub and press enter.

Place a question mark and space in front if it is a function.

Or use Call, e.g.:
Call MyProc

This assumes that MyProc is a function in a standard module (i.e. not a
Private procedure, nor in the module of a form/report.)
 
Ah, but this code is in a form. Are there any options here, short of
starting the code through a button on the form?
 
If the procedure is called MyProc, and the form is named Form1, remove the
Private from the procedure declaration, and enter:
Call Form_Form1.MyProc

You will see the "Form_Form1" as the name of the module in the Title bar of
the VBA window.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re: Using the Immediate window to run a sub 4
Problem with debugging in modules 2
Debug not working after install of 2007 1
Immediate Window code --> listbox value 3
Form Name as Variable 1
Passing Userform Control to Subroutine 2
User defined type not defined? 2
Public variable 1

Back
Top