User defined table function in XL2003

  • Thread starter Dr. Wolfgang Hintze
  • Start date
D

Dr. Wolfgang Hintze

Hello all,

I used to employ this feature many times earlier.

My problem is: I would like to use a user defined function in Excel
2003.

After having define a function, say Nrm(), in a module belonging to a
table or to general, how can I make it available in my table?

It does not appear in the list after INSERT > USER DEF. FUNCTION.

Any help is greatly appreciated.

Wolfgang
 
N

Niek Otten

The function should be in a General Module, not a sheet module or workbook
module.
So, in the VB Editor: Insert>Module. Type or paste your code there
 

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

Top