VB connects to Excel, and you can directly use Excel controls or Excel class libraries.
Suggestion:
1. Understand VB first and write a few simple programs. If you know VB, then skip the first step.
2. Establish a simplest database.
3. Download a VB connection access routine, ADO is easy to find, have a general look.
4. Download a routine of VB connecting to Excel, and have a general look.
5. Try to modify the routine and connect to your own database, excel.
6. Download the tutorial and learn advanced development. Excel is not needed, ADO has many advanced skills.