VBA – Add a C# library to a VBA project – Part 2

After writing the simple part here I think that it is a really good idea to introduce IntelliSense as well 🙂

Something like this in the code:

intellisense01

 

And like this is in the library:

intellisense02

 

The question is always one – how? The answer in this case was a bit unexpected for me – through Interfaces in C#. They take up the responsibility for IntelliSense and work pretty well.

Thus, the following code does the magic:

The whole project (including the funny VBA code from the first screenshot and the strange C# class) is available in my GitHub repo here.

About

VBA Developer

Tagged with: , ,