Apr 03 2021 07:16 AM
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 dans la liste des fonctions Excel, ni dans les suggestions (autocomplete) lors de la saisie.
J'ai essayé le paramétrage de sécurité, l'utilisation d'un alias par le gestionnaire de nom (exemple des fonctions LAMBDA).
Pas de rubrique "Personnalisées" dans la Boite de dialogue Fonctions accessible depuis la Feuille de calcul.
Apr 03 2021 08:54 AM
Maybe I'm not the most appropriate to give you a suggested solution, but ...
With your permission, if I can recommend you, explain your problem in detail. So you can get a solution proposal to your problem much faster.
At the same time, it is much easier for someone who wants to help to understand the subject.
A win-win situation for everyone.
It is also helpful to know the operating system and Excel version, as different approaches may be required depending on the Office version and OS.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Apr 03 2021 09:21 AM
Apr 03 2021 11:43 AM
Apr 03 2021 11:59 AM
Apr 03 2021 12:18 PM
Apr 03 2021 12:37 PM
Apr 04 2021 01:11 AM
Apr 08 2021 09:07 AM
@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 :)
Apr 08 2021 01:49 PM