12 hours ago, Sven Groot wrote
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.