VBA wouldn't be too bad if the IDE wasn't still exactly the way it was in VB6 (even in Office 2013).
Certain behaviors, like the modal dialog for a syntax error whenever you move your cursor away from a line that has an error on it, are just extremely annoying. Another pet peeve is the way the editor capitalizes names based on declarations. If I declare a variable named "width" (without capitals), then any reference to e.g. a property named Width in the same function will automatically be cased like my variable rather than the proper casing for the property. Since VBA is case-insensitive it doesn't affect functionality, but it looks messy.
The editor's UI also looks really incongruous in recent versions of Office.
VSTO and stuff are nice, but if I quickly need to move all graphs ten points to the left or something, it's much easier to quickly write some one-time-use code in VBA, so I'd really appreciate it if they gave the editor some love.
