One of the cool features of VSTA is that it can exist side by side with VBA in the host application. This allows hosts to slowly migrate their users to managed code over time. Summit has created a sample walkthrough showing you how to integrate VBA and VSTA into the SDK sample application, ShapeApp.
Integrating VSTA with an Unmanaged VBA-Enabled Application
Paul StubbsProgram Manager