Guides to Function Modules
Last updated
Last updated
The function modules are stored inside the files with “CL_xxx” for different categories
In order to improve the stability of the code, the “Option Explicit” is used, which means all the parameters must be defined first before use.
Among the Modules, the “CL_Ribbon_controls”, “CL_SYSTEM”, “CL_SYSTEM_SUPPORT” are only for system purpose (private module, thus hidden from user)
You can open any of the module document or create your own ones as well to add the functions. It is suggested to add clear comment for the functions. (well, seems I did not do a good example, but you can😊)
Excel cannot natively show the dynamic functions guides, thus we use a third-part add-in called “EXCELDNA” to do the job. (thus you will see two files “ExcelDna.IntelliSense.xll” and “ExcelDna.IntelliSense64.xll” along with the Main excel when you download it. There is also way to merge the ExcelDNA into the main excel, however will perhaps we will do so for the next build.) In the main excel there is a hidden spreadsheet named “_IntelliSense_” which defines all the function guides.
A guide for Excel DNA
For VBA and C# based functions.
