custom field formulas

[JimS]

I have several custom fields that have formulas that are complex enough so
that they are hard maintain. It would seem that they would be more efficient
in VBA. Instead of using the custom formula is there a way to do the same
thing in VBA. Is there some specific reference material to help me?

 

[Mike Glen]

Hi Jim,

Try posting on the developer newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP

 

[JackD]

Custom fields have some advantages and disadvantages. It is possible to do
every calculation which is possible in a custom field by using VBA, but you
lose the advantage of automatic recalculation.

See my article on Custom formulas here:

http://zo-d.com/blog/archives/programming/working-with-custom-field-formulas.html
Then poke around the site for more VBA articles and links.

If you post the formula here (or in the developer group) perhaps someone
will be kind enough to convert it to a macro for you.