Running Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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]
 
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
 
You must log in or register to reply here.

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

How can i get vba to get a value from a combobox and make it run a macro 0
Button in toolbar that runs vba code 5
CommonButton was out of function since Dec 2014 6
New computer w/ Vista won't open my Access 07 Sales DB -Help 2
Access #Error & Excel Pivot 0
Running an Access Module 2
Access 2007 Switchboards 1
Pasting cell contents into a macro 1

Back
Top