Editing user defined functions

  • Thread starter Thread starter Fan924
  • Start date Start date
F

Fan924

I created a user defined function in Excel 97. The function works and
I can access it in excel. I made the mistake of closing the window in
visual basic. Now I can't find the function for editing. The macros I
can find, not the user defined functions. Is there a magic word I
should know?
 
Functions do not show up in the macro list.

In Tools>Macro>Macros, just type in the name of your UDF and "Edit"

Or Alt + F11 to open VBE then d-click on the module that holds the Function.


Gord Dibben MS Excel MVP
 
You could try this, too:

Activate the workbook that owns the function.
F5 (or ctrl-g or edit|goto)
type the name of the function and hit enter
 
Good trick Dave.

Never knew about that.


Gord

You could try this, too:

Activate the workbook that owns the function.
F5 (or ctrl-g or edit|goto)
type the name of the function and hit enter
Click to expand...
 
I'm not sure if I learned that in the newsgroups or if I did something wrong
that turned out ok!
 
Back
Top