First the function is in the wrong place. It needs to be in a general code
module, not a worksheet module. In the VBEditor right-click on your
VBAProject, Insert, Module and place your function there. Now when you open
the list of functions, scroll down to User Defined and you will find your
function listed there.

Mike F

"anjanesh" wrote in
message ...

Hi

I opened Tools Macro VB Editor and on Sheet1, I right-clicked and
selected View Code. I pasted my code in there.

Now, how do I get my function foo() shown up in the Function list
(*-f-*) ?

Thanks


--
anjanesh

Freelance Developer
------------------------------------------------------------------------
anjanesh's Profile:
http://www.excelforum.com/member.php...o&userid=27132
View this thread: http://www.excelforum.com/showthread...hreadid=568743