I am trying to extend the functionality of my Excel VBA Projects with a C# Class Library in Visual Studio. I have selected the required settings in my Library Project to create a .tlb file, for my VBA projects to reference.
I can create objects and call members - so everything works correctly!
When I create an object, I do receive intellisense for the classes.
However, when developing in VBA no intellisense exists for the members of my objects. I did set up XML definitions for my members, such as:
/// <summary>
/// A Summary of my members function
/// </summary>
/// <param name="ParamName"></param>
But I don't even receive a list of members to start with! :(
[ComVisible(true)] is also set for these members.
Is there something extra I have to do for this feature to work in a VBA project or is this simply not supported in .tlb files?
Thanks