View original (French)

ConvNumberLetter function

Solved
CECO_6776 Posted messages 5 Status Member -  
 DAVIDO -
Hello,

Please let me know how to make the ConvNumberLetter function appear in the list of Excel functions every time I open an Excel file?

Best regards

Configuration: Windows / Chrome 78.0.3904.70

2 answers

  1.
    ALS35 Posted messages 1034 Registration date   Status Member Last intervention   147
     
    Hello,

    You need to copy the module that contains it to the personal macro workbook, in the VBA window it's called PERSONAL.XLSB.
    When you close Excel, save this personal macro workbook.

    Best regards
    0
    1. CECO_6776 Posted messages 5 Status Member
       
      Thank you ALS35 for your response.

      It works for the workbook I'm using, but when I open another workbook, I can no longer see this function. How can I make Excel remember it like the SUM function, for example?
      Best regards.
      0
    2. ALS35 Posted messages 1034 Registration date   Status Member Last intervention   147
       
      Hello,

      I told you, you need to put this function in the personal macro workbook (PERSONAL.XLSB).
      How did you manage to put this function in your file?
      Otherwise, open your Excel file, press Alt + F11, this opens the VBA editor, in the left window you should see a folder VBAProject (the name of your file) with a subfolder Modules where you should find a module containing your concerned function.
      Do you also see a folder VBAProject (PERSONAL.XLSB)?

      Best regards
      0