New to User Defined Functions....stumped.

[gblasius]

I am trying to implement a function which calls excel function Beta.dist. A simplified example of what I am trying to do is:

Function ReturnBeta(L,a,b)
    ReturnBeta = BETA.DIST(L, a, b, 1)
End Function

When I try to implement this function, I get the error message:
" Compile Error: Sub or Function not defined"

? I'm stumped.

[MrShorty]

You access excel's function through the worksheetfunction object http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

[gblasius]

So I tried that...modified my code to read

ReturnBeta = Application.Worksheetfunction.Beta.Dist(L,a,b,1)

...and now get message

"Method or Data Member not found"

I also tried renaming the function as

Application.worksheetfunction.betadist()

No luck

[Norie]

Try Beta_Dist.

[MrShorty]

Not sure what to tell you. This

testbeta = Application.WorksheetFunction.BetaDist(x, a, b) 'x=.5,a=.5,b=.1

worked just fine for me. Double check for typos, spelling errors, invalid arguments, correct number of arguments, etc.

[gblasius]

OK. It's even weirder then that. I hope I can describe it: I am trying to evaluate the cumulative distribution function, and so, per the syntax for the Beta.Dist function, there should be a fourth argument supplied to the BetaDist Function, being logical TRUE. Now, if I pass the first three variables and TRUE to the Application.Worksheetfunction.BetaDist(x,a,b,1), the function evaluates to "#VALUE." If I pass the first three variables and FALSE to the function, I get a result, which is the same result as using the Beta.Dist function in Excel but with the fourth argument set to TRUE - eg, I am only getting an evaluated function if I specify FALSE to the UDF, but that result is the same as supplying the same variables and TRUE to the excel function.

[Norie]

If you use BETA_DIST there's a 4th argument.

[gblasius]

Yes, thanks... found out about Beta_Dist, but got a weird error trying to implement that. In looking on the web, it looks like the BetaDist function only evaluates to the *** function, and hence explains the error message and the weird properties.

This is completely weird and typically Microsoftian.

[Norie]

Both BetaDist and Beta_Dist worked fine for me in a function.

How exactly did you use them?

[jeffreybrown]

@gblasius,

Administrative Note:

• Please follow Forum Rule #3 and use code tags.
• Added for you this time, but please use them in the future…Thanks.