The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Resources on learning VBA, or programming in general.
Casually Hardcore
Once an Asshole. Trying to be better.Registered User regular
Once an Asshole. Trying to be better.Registered User regular
Hello,
So I'm like super good at Excel but I want to take it a step farther and actually learn how to use VBA. I know how to make simple macros but at the end of the day these macros ends up being a thousand 'if then' statements that I know isn't the most efficient way of doing it.
Though, I think it's less about learning how to use VBA and learning how to actually program. But since most of my time is with Excel, I guess learning how to program through VBA would be ideal (though I heard VBA is a terrible program).
Anyways, what are some good resources to learn programming and VBA; preferably at the same time?
So I'm like super good at Excel but I want to take it a step farther and actually learn how to use VBA. I know how to make simple macros but at the end of the day these macros ends up being a thousand 'if then' statements that I know isn't the most efficient way of doing it.
Though, I think it's less about learning how to use VBA and learning how to actually program. But since most of my time is with Excel, I guess learning how to program through VBA would be ideal (though I heard VBA is a terrible program).
Anyways, what are some good resources to learn programming and VBA; preferably at the same time?
0
Posts
Codecademy
Codeschool
Open CourseWare
For your purposes, you really only need a simple introductory programming course, as VBA coding in Excel is just recording a macro an then making it better. For this, all you really need to know is loops, variables, and coding best practices.
Depending on how deeply you want to go, Coursera/Codecademy have simple interactive tutorials that should get you going, and places like Open CourseWare have full semester-long courses in CS.
BF3 Battlelog | Twitter | World of Warships | World of Tanks | Wishlist
Opencourseware has some great intro stuff.
I would also suggest picking a good language to learn programming fundamentals on (I personally prefer Python), then moving to VBA. That path may take longer, but in the end it would be easier and you will be more flexible than trying to go the other direction.