Using Excel defined functions in UDF

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matthew.M.Snow@gmail.com - 28 Jun 2006 17:16 GMT

I'm trying to create a UDF that allows users to input to binomial
experiments and the results will be a p-value for comparing the
proportions.

My function crashes everytime I try to use an excel built in function
like

SQRT(X) or NORMSDIST(X)... etc

SQRT I got around by using (X) ^ 0.5 and I found a formula that got me
close the normdist, but I'd like to use the exact formula in excel

Thanks,
Matt

Reply to this Message

Bob Phillips - 28 Jun 2006 18:57 GMT

VBA has its own Sqrt functiojn called Sqr.

One way to get at functions that don't work in VBA bnormally is tio use
evaluate, such as

Application.Caller.Parent.Evaluate("SQRT(" & inVal & ")")

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> I'm trying to create a UDF that allows users to input to binomial
> experiments and the results will be a p-value for comparing the
[quoted text clipped - 10 lines]
> Thanks,
> Matt

Reply to this Message