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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple User Defined Categories in Insert Function Form 2
excel spreadsheet functions written in vba 1
Using code to edit spreadsheet formulas 5
user defined function which increase consecutively while passingbelow cells 12
User Defined Function being called by changes to an independent workbook 13
To SQL Expert: VBA Function that Calls SQL Query 3
User defined function 5
User Defined Function 5

Back
Top