How to find new UDF to edit

  • Thread starter Thread starter John Keith
  • Start date Start date
J

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)
 
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.
 
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.
Click to expand...

Thanks Dave, I'm still learning!


John Keith
(e-mail address removed)
 
In Tools>Macro>Macros you can type in the name of your UDF and then "Edit"


Gord Dibben MS Excel MVP
 
In Tools>Macro>Macros you can type in the name of your UDF and then "Edit"
Click to expand...

Gord,

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


John Keith
(e-mail address removed)
 
Back
Top