How to find new UDF to edit

[John Keith]

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
(e-mail address removed)

 

[Dave Peterson]

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]

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
(e-mail address removed)

 

[Gord Dibben]

In Tools>Macro>Macros you can type in the name of your UDF and then "Edit"


Gord Dibben MS Excel MVP

 

[John Keith]

In Tools>Macro>Macros 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
(e-mail address removed)