So first of all, everyone must realize that VBA is dead... So if you are migrating code to 10, I would strongly suggest that you don't do it to just VBA. Follow the new Add-In paradigm that uses .NET or you will end up migrating again when VBA is completely pulled out of ArcGIS.
Secondly, there are a lot of schematic samples available in the desktop developer kit that show how to work with the api. So just saying you need NgProject isn't descriptive enough, we need to know what you are actually trying to accomplish. At 10, you can do most everything from the diagramclass or elementclass, but again, depends on what you are trying to accomplish.
So let us know what you are doing and I will try to help you through it.