Someone asked today something related to this in the MSDN forum and since I remembered being there and that the solution was not very intuitive, I wrote this article:

HOWTO: Add an event handler from a Visual Studio add-in
http://www.mztools.com/articles/2008/MZ2008006.aspx