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

Similar Threads

Excel - Wich Function should I use? 1
Problem with SET & REF function 0
User Defined Function 5
User defined function 10
Assigning function to Ctrl+Space and it worls wrongly 2
user defined function which increase consecutively while passingbelow cells 12
Insert Index into a Table 1
How to call module function or sub from the Add In? 3

Top