Attached is a working example. The code was thrown together quickly but is functional.
Two things you must do in order to access a .NET class from VB:
1. You have to mark which classes should be visible to COM.
2. You have to make the .tlb. Easiest way is to check 'Register for COM Interop' on the Build tab of your Project Properties.
The way this program is written, it exposes the class to COM but we are not controlling the GUID so evertime we build, a new ID is made/versioned and we have to re-reference the dll.
In this case if you use the References dialog in VB, you will need 'ColorDialogFromVBA'
You can find a little bit of information here: http://msdn.microsoft.com/vbrun/mspress/c0961587x.pdf#search=%22.net%20%3A%20COM%20Interop%22
Ronnie Wilkins, Jr.