VBA sucks

[GuidoHunter]

Okay, so it doesn't suck, and it can make Excel extremely useful, but it sure can be annoying.

[run subroutine]
VBA: Your program's fine!
[change a numerical input to a different numerical input]
VBA: Whoawhoawhoa! You're referencing outside of the scope of this array!
Me: WHY DIDN'T YOU TELL ME THAT EARLIER?!

I just learned this this summer for work, but I probably never would have if I didn't have to. It's similar in structure to C++ (the only other language I know), but its syntax is quite strange and seemingly simplistic, so much so that I'm amazed that it has the capabilities that it does.

So, anyone else use it?

--Guido

http://andy.mikee385.com

[TheRapingDragon]

When you said VBA, I, and I'm sure a bunch of others, thought you were talking about the GBA emulator "Visual Boy Advance".

I've never even heard of the VBA coding language, but if it's similar to C++ then I wouldn't have a clue.

[Afrobean]

Originally Posted by TheRapingDragon

When you said VBA, I, and I'm sure a bunch of others, thought you were talking about the GBA emulator "Visual Boy Advance".

I've never even heard of the VBA coding language, but if it's similar to C++ then I wouldn't have a clue.

Are you joking? It's visual basic, dude.

I was planning on learning visual basic since it was the only programming language my high school had a class for. Then later, when it came time for me to actually sign up for the class, I learned that they no longer offered the class even though they still for some reason had it on EVERYTHING that mentions available classes. Eventually, I settled for going to a for dual enrollment at a tech school where I got some basic computer work and at the end, I learned the basics of C++. Probably a better choice in the end, since I've heard some bad things about vb.

I never really got the point of using vb in applications like that though. I could never think of anything where it would have an effective use.

Also: just read the wikipedia article about it and it mentioned AutoCAD. I used AutoCAD a lot in high school. I thought the language it used for macros was something else though.

[TheRapingDragon]

Originally Posted by Afrobean

Are you joking? It's visual basic, dude.

Oh right, I know visual basic, well, most of what I remember is basic. I don't care much for coding or computer languages, that includes VB. Most I've done is messed around to make patterns loop infinitely and whatnot.

[GuidoHunter]

Originally Posted by Afrobean

Are you joking? It's visual basic, dude.

Not quite. It's Visual Basic for Applications, and there are significant differences between the two. Code certainly wouldn't be interchangeable.

I never really got the point of using vb in applications like that though. I could never think of anything where it would have an effective use.

I never would have dreamed of all the stuff that Excel could do with VBA macro support until I came and worked here. Near every facet of Excel is worked over even before people exceed its limitations and then start writing macros for it in the corporate world.

--Guido

http://andy.mikee385.com

[Omeganitros]

I don't know nothin' 'bout your languages, but I have enough experience with AutoCAD to know that I despise it with a passion.

[GuidoHunter]

Hahaha@the reference.

But if you don't like AutoCAD, engineering probably isn't for you. Maybe try Solid Works? It's Halliburton's drafting software.

--Guido

http://andy.mikee385.com