Cut and Paste procedure then test it in Immediate window

N

nick kress

I am unable to cut and paste procedures from your site and test it in
Immediate window
i type in Debug.Print procedureName just before End function / Sub
When I type in the procedure name in Immediate window ( reply is Function /
Sub) not defined
What am I doing wrong?
 
D

Douglas J. Steele

You're not trying to copy all of the code into the Immediate window, are
you?

The code needs to be copied into a module. Then you can type the name of the
procedure in the Immediate window to execute the code. (It's not necessary
to save the module in order to run the code). Remember that when you do save
the module, the module must have a different name than the routine(s) within
it.
 

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

Immediate Window? 2
Using immediate window 3
Size limit to Immediate Window in Code View? 3
Function and Immediate window 5
Create form and controls using vba 0
Dont understand Immediate windows ? 11
calculation with NOT EQUAL TO 6
Use Immediate window to execute a procedure 10

Top