Hi
use a macro like

public function my_function()
my_function=1234
end function

and in a cell type:
=MY_FUNCTION()

See: http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"David Laub" schrieb im Newsbeitrag
...
Can I use a VBA function I write myself in a formula? It appears to
be
impossibe...



Thanks

David Laub