Develop Office Client Applications using Visual Studio
In Walkthrough: Adding Controls to a Worksheet at Run Time in an Application-Level Project, you can see to add host controls at run time in an application-level add-in by using Visual Studio 2008 SP1. This video is posted to the How Do I Videos - Visual Basic page, part of the Visual Basic Developer Center.
How Do I: Add Controls to a Worksheet at Run Time in an Application-Level Project?
Mary Lee, Programming Writer.
This as been very well explained with more samples in the https://www.packtpub.com/vsto-3-for-office-2007-programming/book
book. refer the same