Forum Discussion

Jeanga's avatar
Jeanga
Copper Contributor
Apr 03, 2021

fonctions personnalisées provoquent une erreur #NOM?

Bonjour, mes fonctions personnalisées provoquent une erreur #NOM? dans la cellule. Mes fonctions donnent un résultat correct lors d'un appel depuis un SUB en VBA. Mes fonctions n'apparaissent pas d...
excel
Formulas and Functions
Macros and VBA
Jeanga's avatar
Jeanga
Copper Contributor
Apr 08, 2021

@everyone

I found the way to use my customized Functions in my Sheet.

Simply declare the functions in a CLASS MODULE, not in the Workbook or Worksheets code modules.

 

Thanks to those who tried to help me.

If one (or more) of you gave me this trick, please apologize. I didn't understand your meaning.

I don't remember I had to declare my functions in a Class Module before.

Well, it works, I love to code.

Thanks to all 🙂

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Apr 08, 2021

Jeanga 

Thank you for the update, though  I have never had to use a Class module for the purpose of creating a UDF.  I notice an earlier post from JMB17 that asked whether you were using a standard module.  It appears that he was at least on the right lines.