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.