5 ms·
You are correct. But, that's about the only difference between VBA and VB. I was a VB developer for 10 years before I wrote my first VBA application (in Excel),
by vic20forever 3mo ago
You are correct. But, that's about the only difference between VBA and VB. I was a VB developer for 10 years before I wrote my first VBA application (in Excel), and I was surprised when everything I tried to do in VBA just worked(TM).
- pjmlp 3mo agoThere are plenty more like VB 5 and 6 changed component architecture from VBX, to OCX (COM based), while adding features to do COM development in VB directly. VB 5 introduced proper AOT compilation, based on VC++ backend, which was further improved in VB 6. The debugger / REPL experience was much better on VB than VBA. You cannot really use most VB components in Excel / VBA unless AddIn support is enabled.