Link to home
Start Free TrialLog in
Avatar of BladdyK
BladdyK

asked on

How Do I get my VB.NET DLL functions to show up in VBA Object Browser?

I recently coded a VB.NET class in Visual Studio 2010 which has a bunch of public functions in them.  I compiled the DLL and referenced it in Excel VBA.  I can see the class name in the object browser, and I can see a public structure I have in the DLL, but none of the functions in the class are visible in the object browser.

What's funny is that I can create an instance of the class and call the functions, but none of the functions show up in Intellisense.  How can I get those functions to show up in the object browser?  Is this an issue of late vs. early binding?
ASKER CERTIFIED SOLUTION
Avatar of kaufmed
kaufmed
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BladdyK
BladdyK

ASKER

That definitely helped.  The other missing component was to create an interface for my class.  When I did that, I could see all of the functions in the Object Browser.

Thanks!
Avatar of BladdyK

ASKER

The solution was half of what I needed.  It was necessary to decorate my class, but I also need to implement an Interface to show the various functions in the object browser.