Being the thoughts and writings of one Gustaf Erikson; father, homeowner, technologist.

This category contains posts about computing, programming, and development

Tuesday, 2005-09-27


Coding VBA

The Daily WTF:

At some point in your career as a programmer, you will be tricked into maintaining a VBA (Visual Basic for Applications, aka Word/Excel macros) application. I’d tell you how to get out of it, but I really don’t think it’s possible. All I know is that at some point between admitting to have knowledge of Excel and cursing under your breath while typing VBA, you will be coaxed into giving some “quick help” on a spreadsheet.

Then there follows an astounding example of horrible horrible VBA code, and the replacement: 3 lines.

There were some dangerous moments in the beginning of my current employment when people were nerving themselves to ask me for VBA help, but now I think it’s forgotten. And if it isn’t, I have to hunt down those people and administer more memory suppressants…

Submit a comment

Please enter comments as plain text only; HTML is not supported. Submitting an URL is optional.

Comments are moderated and may not appear immediately.

Comments are closed for this story.