J
Jim Pockmire
How can I start a subroutine from the Debug or Immediate window?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J. Steele
Type its name and hit Enter
A
Allen Browne
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.)
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.)
J
Jim Pockmire
Ah, but this code is in a form. Are there any options here, short of
starting the code through a button on the form?
starting the code through a button on the form?
A
Allen Browne
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.
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.