Custom XF formula for excel add-in
Is it possible to create a custom XF formula for users to access within the excel add-in? We want to create an member offset formula.
Forum Discussion
Alt-F11 to open the VBA Editor
Insert a new module
Add your code:
Function XFMemberOffset(referenceValue As Double, memberValue As Double) As Double
Dim Result as double
' Calculate something here
'return the calculated value
XFMemberOffset = Result
End Function
Save your workbook as macro enabled (.xslm)
Alt+Q to close the VBA Editor
In any cell in your workbook, you can now use your custom function: =XFMemberOffset(A1, B1)