If anyone has an example of VB6 being faster than VBA that we can test contact us.
Performance in both of these areas is very similar between VBA and VB6 COM Add-ins.
COM add-ins (DLLs) run in-process with Excel, just like VBA so the overhead of working with Excel objects is similar.
VBA and VB6 are basically the same product and execution speed of the actual language seems to be similar.
Typing code is 20% of the job - the other 80% is spent , the 80% can be more productive.