Running Functions

B

Bill H

When I press the "Run" button in the VBA IDE, a window comes up asking for a
macro name. Can't I just run the function from this window?
 
J

John W. Vinson

When I press the "Run" button in the VBA IDE, a window comes up asking for a
macro name. Can't I just run the function from this window?
Click to expand...

What I'll usually do is make the Immediate window visible (Ctrl-G does so) and
type

?MyFunctionName(3, "foo", #1/1/2007#)

or the like.

John W. Vinson [MVP]
 
K

Ken Sheridan

It sounds like your function takes one or more arguments. In which case you
can call it from the debug window (aka immediate window) passing in values
for the argument(s). If the function takes no arguments you can call it from
the toolbar or by pressing the F5 key.

Ken Sheridan
Stafford, England
 
Top