# Can a Macro read a Public Function?

#### MNpoker

##### Board Regular
I am building a macro and one of the formulas in the function is a customfunction I built.

I am getting an error.

Here's a piece of the code.

Lambda = LossCurves.Cells(X, 1)
Theta = LossCurves.Cells(X, 6)
Maximum = LossCurves.Cells(X, 5)
Freqrnd = Rnd
Freq = PoissonInv(FreqRnd,Lambda)

The PoissonInv function is defined in my library:
Public Function PoissonInv(CDF, meanX)

If CDF < 0 Or CDF >= 1 Then PoissonInv = "The curve must be evaluated between 0 and 1": Exit Function

X = 0
p = Exp(-meanX)
tp = p

Do While CDF > tp
X = X + 1
p = p * meanX / X
tp = tp + p
Loop

PoissonInv = X

End Function

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

#### Norie

##### Well-known Member
What error are you getting?

Where is the function located?

#### MNpoker

##### Board Regular
Compile Error
Sub or function not defined

The public functions are located in
ProgramFiles/Microsoftoffice/Office11/Library/CustomFunctionsdefined2.XLA

And the add-in is checked. The functions work in the excel sheet.

Bump

Replies
0
Views
192
Replies
2
Views
408
Replies
4
Views
510
Replies
10
Views
703
Replies
2
Views
339