Editing user defined functions

[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?

 

[Gord Dibben]

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

 

[Dave Peterson]

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

 

[Gord Dibben]

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

 

[Dave Peterson]

I'm not sure if I learned that in the newsgroups or if I did something wrong
that turned out ok!

 

[Fan924]

Thanks Guys