how to? custom worksheet function using VBA
Sorry Fred, I just realized your first post mentioned Excel 5, where
the method for creating UDFs might have been radically different. Yes
you put the code in a standard module by pressing Alt-F11 to access
the VBIDE, then going to Insert Module in the workbook in which you
want to use the function.
On Sep 20, 8:40*pm, "Fred Allen" wrote:
Okay, the UDF has to be in a Module, it can't be in the code for a worksheet
or even ThisWorkbook.
"Fred Allen" wrote in message
...
I did just that, and that is what the MS article says. So at least I know I
am on the right track (with VBA UDF, which operate differently than the old
XLM UDF). I guess it is some trick in Excel 2007 (or Vista).
Thank you for confirming how I thought it was supposed to work. That does
help!
|