how to create user-definied-function for excel with vb
- Press Alt+F11 to open the Visual Basic Editor (on the Mac, press FN+ALT+F11), and then click Insert > Module.
- Create you function in this module
- save it as Excel Add-In, into the default folder
C:\Users\user_name\AppData\Roaming\Microsoft\AddIns - enable this add in
File > Excel Options > Add-Ins > Manage > Excel Add-Ins > Go >
In the Add-Ins dialog box, select the check box beside the name you used to save your workbook
https://docs.microsoft.com/en-us/dotnet/visual-basic/