User Defined Functions

[Pat Whitted]

I want to create a User Defined Function to perform a calculation in a
custom field in Project 2003. I've written the function, but can't
seem to reference it. I did a search on the Usenet Groups and saw an
entry from October 2000 that stated that UDFs were not supported. Is
that still the case? If not, what do I need to do to be able to
reference my function? - Pat

 

[JackD]

That is true.
You can not reference a user defined function. However you can use a formula
in the custom field so if you can express your function in the form of a
formula then you may be OK.
The alternative is to use VBA and write a macro which performs this
function. The downside of this is that it does not automatically recalculate
in the way that the formula would. The upside is that you can write just
about any function imagineable.

What is the function? If you post it here then I can tell you if it is
possible to recast it as a formula.

-Jack

 

[Pat Whitted]

Thanks for the offer, Jack, but I was already successful in turning my
function into a workable formula. My original intent was to reproduce the
RoundUp function that is available in Excel, but decided to just make any
values less than 1, 1, and use Round for all other numbers. Thanks! - Pat