http://rubberduckvba.com/

I think it has both on demand re-formatting of modules/project and automatic caret placement and insertion of closing bracket/quotes like most modern code-editors (e.g. N++ and VS) but personally don't use it so might be wrong.

cheers,
</wqw>