I don't have Excel 2007, but doesn't it work the same way? You just
put the UDF in a standard code module in the workbook where it's going
to be used. For example:

Function MySum(intNum1 As Integer, intNum2 As Integer) As Integer
MySum = intNum1 + intNum2
End Function


Then just put "=MySum(1,2)" in your worksheet cell.

??

--JP

On Sep 19, 10:01*pm, "Fred Allen" wrote:
hello. new user here.

Is it possible to create "custom" worksheet functions in VBA in Excel 2007?

I used to do this quite easily in Excel 5. I can't find how to do this in
the new version.

This MS article doesn't seem to work for the 2007:http://office.microsoft..com/en-us/e...548461033.aspx