Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Call vba function from field formula in MS Project

Posted on 2009-05-20
1
Medium Priority
?
1,640 Views
Last Modified: 2013-11-15
I'm trying to reference a custom vba function from a field formula in MS Project:
I'm in the Gant View:
Right Click on Number1 Column and select Customize Fields.
Highlight field Number1 and click Formula button.
This brings up the formula editor where I enter the reference to my custom (public) function in Module1, for example:  my_function("Foo") where "Foo" is defined as a string parameter in the function.
I get the error:  "The formula returns a syntax error or contains a reference an unrecognized field or function name"
The function works fine when called from a subroutine in VBA.
How do you call a custom VBA function from a field formula?
0
Comment
Question by:tlanza
1 Comment
 
LVL 10

Accepted Solution

by:
harisrashid earned 1500 total points
ID: 24641204
you cannot associate vba code with field formula. associate a macro or subroutine and call it manually or on some event.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Loops Section Overview

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question