I am trying to write some DLL's to be accessed by Excel.
But I have never before even written an UDF for Excel
and cannot get the most basic stuff to work.
I opened a
VB code window from Excel and copied into it the code below
(from a post by Kevin Stecyk).
Option Explicit
Public Function Test(dAmt As Double) As Double
Test = dAmt * 2
End Function
In the spreadsheet, I entered in a cell, =Test(5)
The answer was #Name?
What am I missing?
TIA, JohnH