3 ms·
Cool. What about a modern setup for VB/VBA? The last time I had to define a custom statistical function for Excel and had limited time I felt handicapped and an
by qwerty456127 4y ago
Cool. What about a modern setup for VB/VBA? The last time I had to define a custom statistical function for Excel and had limited time I felt handicapped and annoyed by how dumb the code editor (still the same as in VB5) is.
- pjmlp 4y agoThat would be VB.NET with the Office SDK. https://learn.microsoft.com/en-us/dotnet/csharp/programming-guide/interop/walkthrough-office-programming https://learn.microsoft.com/en-us/dotnet/csharp/programming-...
- wolpoli 4y agoDepending on your requirement, it might be better to create custom functions in Javascript [1]. One difference is that the functions are tied to the Excel installation, and not on the workbook like VBA. [1]: https://learn.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-overview https://learn.microsoft.com/en-us/office/dev/add-ins/excel/c...