I created my first function and it works great but now I need to edit
it to make some additions and improvements. But how do I find the
code? When I select view macros the function does not appear in the
list. I think this function was put in a general module but I sure
can't locate it. The fucntion is callable and working from other
macros so I know it's out there somewhere.

Thanks


John Keith

Open the workbook with the macro.
Hit alt-f11 to get to the VBE where macros live.
Hit ctrl-r to see the project explorer (like windows explorer)

Find the module you put the code in and you'll be able to edit the code.



John Keith wrote:

I created my first function and it works great but now I need to edit
it to make some additions and improvements. But how do I find the
code? When I select view macros the function does not appear in the
list. I think this function was put in a general module but I sure
can't locate it. The fucntion is callable and working from other
macros so I know it's out there somewhere.

Thanks


John Keith


--

Dave Peterson

On Wed, 07 Oct 2009 20:20:47 -0500, Dave Peterson
wrote:

Open the workbook with the macro.
Hit alt-f11 to get to the VBE where macros live.
Hit ctrl-r to see the project explorer (like windows explorer)

Find the module you put the code in and you'll be able to edit the code.

Thanks Dave, I'm still learning!


John Keith

In ToolsMacroMacros you can type in the name of your UDF and then "Edit"


Gord Dibben MS Excel MVP

On Wed, 07 Oct 2009 19:03:12 -0600, John Keith wrote:

I created my first function and it works great but now I need to edit
it to make some additions and improvements. But how do I find the
code? When I select view macros the function does not appear in the
list. I think this function was put in a general module but I sure
can't locate it. The fucntion is callable and working from other
macros so I know it's out there somewhere.

Thanks


John Keith

On Thu, 08 Oct 2009 07:33:42 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

In ToolsMacroMacros you can type in the name of your UDF and then "Edit"


Gord,

Thank you, that works nicely also! So many little hooks, how to find
them all?


John Keith