Calling a Add-in function from Excel's VBA
Posted
by graham
on Stack Overflow
See other posts from Stack Overflow
or by graham
Published on 2010-06-17T16:08:28Z
Indexed on
2010/06/17
16:13 UTC
Read the original article
Hit count: 227
vba
I am using an Excel Add-in for an Erlangs: http://abstractmicro.com/erlang/helppages/ref-erlbblockage.htm
I try to call the Erlang-B function within the Add-in from within VBA thus:
Function Erl(Erlangs As Double, Capacity As Double)
Erl = Application.WorksheetFunction.ErlbBlockage(Capacity, Erlangs)
End Function
...but it doesn't work. I get #VALUE! returned in the Excel cell. I think it is because the function is not part of standard Excel (it is in the Add-in). So how do I call it?
© Stack Overflow or respective owner
