Chip Pearson has a good rundown of some various tasks in programming the VBE itself, which include:

Adding/Deleting A Module
Adding/Deleting A Procedure
Deleting All Code From A Module
Listing All Modules In A Workbook
Copying Modules Between Projects
…..for starters.

Bookmark: Programming To The Visual Basic Editor

Thanks Ross.