http://www.anthony-vba.kefra.com/vba/vbabasic1.htm
http://articles.techrepublic.com.com...1-5300300.html

HTH,
Ryan--
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Gary''s Student" wrote:

Put it in a standard module.

From the VBA window:

Insert Module

then paste the stuff in. Consider making the UDF Public.
--
Gary''s Student - gsnu200860


"cec34" wrote:

I'm an old-time programmer, but new to VBA in Excel 2007. I've written a
UDF, but so far, I haven't figured out how to test it in the Immediate window
(or the worksheet, for that matter). It compiles without error, but how do I
store it to make it accessible to the associated worksheet?