I have a number of Access functions that I have created for an Access application I am working on. Is it possible to use those functions from an Excel spread sheet? For example, I would like to enter a value in cell A1 and have that value passed as a parameter to my UDF and have the UDF return value appear in cell B1.

The extension of this is if the UDF requires more than one parameter, have have each parameter in a seperate cell say A1, A4 and A6 and have the UDF return value appear in cell B1.

Thanks for the help

Hi, new2access123,

I doubt that Access-Functions deal with Excel-Ranges which would mean to adapt them and place them in a standard module in Excel...

You could try to utilize the AccessUDF by giving path and module name prior to the Function name and by setting a referenece in Excel VBE to Access.

Ciao,
Holger

[ Edit ]A function called from within a worksheet can only affest the cell from which it is called - no other cell(s).[ /Edit ]