Hi,

I am trying to create a UDF that gains its results from an Access database. Is this possible?

I understand how to run queries using ADO and have the results returned to excel but I can't seem to find anything that shows how to use a UDF.

Any help would be greatly appreciated.

Thanks

Tom

Hi!

There's a gentle and brief intro to UDFs in John Green's Excel 2000 VBA (pp 23 - 27).

I'm presuming you are getting data from your db, processing it in a given cell or cells and reading the result there. I'd be inclined to import the data into named cells and then use the UDF to process it.

Alf