- You apparently can't build VBA IDE Add-ins with .Net. I tried hard & got no where.
- The VBA IDE, you will note, is version 5.3 of VB.
- There is also a distinct VB 6 IDE version. They do NOT mix.
- The VBA IDE version does not have many Event handlers. The VB 6 version does.
- Because there are limited event handlers in the VBA IDE version, the drop-down list needs to be populated
by the button to the left (Procs). It's a minor inconvenience for all the benefits.
- I tried to get at the events that I wanted via the Windows API but found it cumbersome (polite rendition).