In C/C++, when I have a bunch of functions (pointers), I can store them in an array or a vector and call some of them together in a certain order. Can something similar be done in VBA? Thanks!

The VBA and VB6 Add-In Object Models (VBIDE) expose a CommandBarEvents object that have a Click event, and the event signature is: Dim WithEvents CmdBarEvents As CommandBarEvents Private Sub CmdB...

I have an issue with my COM add-in that has been dragging for months, and I can't figure out why. The IDTExtensibility2 implementation has been peer reviewed by Carlos Quintero (the guy behind MZ-...

I'm working with the VBIDE API, and can't assume that the host application is Excel, or any Office app either. So all I know is that I'm looking at a VBComponent, and that its Type is vbext_ct_doc...

Can we read scripts or lines of code to a module in vba? Like we have the include function in php. For example: We store this in Excel somewhere and call the range as xyz line 1 of code line 2 ...