Using a declared function in a module in a cell

[mtheriault2000]

Hello again

Is it possible to use a function that as been declared in a module directly in a cell

Declare Function GV_GetNamedString Lib "C:\Program Files (x86)\TS Support\MultiCharts\GlobalVariable.dll" _
                                    (ByVal strElementLoc As String, ByVal strOther As String) As String

When I'm editing a formula in a cell, I see the function as available, but it give me an "#Value" error

Formula for cell ("D18") =GV_GetNamedString("DataString"; "Error")

In VBA, the formula work and the appropriate value is captured in a variable

Martin

 

[mtheriault2000]

Resolve

Code is working using same code of the previous post.
Thanks again Rory

Martin