3 ms·
> The development environment is not user friendly, the syntax confusing, there’s no support for unit testing – I could go on. The vba ide is pretty good imo.
by vb6sp6 6y ago
> The development environment is not user friendly, the syntax confusing, there’s no support for unit testing – I could go on.
The vba ide is pretty good imo. Lack of unit test frameworks is valid but doesn't stop you from rolling your own.
- bernardv 6y agoLoved VB and VBA but it is too limiting when needing advanced numerical capabilities. Back in the day had to create add-ins making use of compiled Matlab code to get access to decent numerical routines. Eventually moved to Python and never looked back, although I still use Excel for certain tasks. However I do miss the VBA GUI editor built into Excel. It allowed for relatively polished interfaces in record time.
- selimthegrim 6y agoWhat sort of capabilities are you looking for? Newton-Raphson (which Excel has with GOALSEEK)? Sensitivity analysis?
- pjmlp 6y agoAnd a stepping stone into VB.NET in case more power is needed.