Call vba function from field formula in MS Project

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?
tlanzaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
harisrashidConnect With a Mentor Commented:
you cannot associate vba code with field formula. associate a macro or subroutine and call it manually or on some event.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.