what language can you use with visual basic for excel

With my limited ability to create some simple VBA code I reduce a lot of the workload for myself as well as my co-workers (many whom hardly even use autofilters, never knew pivot-tables existed and VBA coding is entirely unknown). Starting to use and learning VBA code has opened a world of possibilities for me, and I've started putting more effort into the userform parts of it as well to make it easier for co-workers in their daily jobs and easier for new people joining projects.

#WHAT LANGUAGE CAN YOU USE WITH VISUAL BASIC FOR EXCEL CODE# Where I spent hours working with lists of information to crossrefence, compare or link together data, I now spend minutes (though I don't tell anyone, so I have hours I can spend reading up on VBA instead, shhh). Having acknowledged the vast possibilities from even the simplest coding in VBA, I've taken an interest towards stepping into the world of programming outside of Excel VBA. Perhaps to make some smaller executables that can handle updating reports on a weekly basis and things like that. I'm sure the possibilities are endless when I start learning the basic, just as learning the basics in Excel VBA opened up a world of possibilities within Excel.īut as I have been reading up on this I find there are a multitude of languages out there. Java, Python, Visual Basic, Visual Basic. I would really appreciate some advice what to go for and, optionally, maybe a brief explanation what the real differences between all these programming languages is.Īgain, thanks for all the Excel VBA help you have given, and thanks for helping me out It feels quite overwhelming and there is no way I can, at least not as the novice I am, begin to learn them all.Īnd that is why I am bringing this up here, where I know there are a lot of gifted and talented people who have worked with this for years (perhaps even decades).Ĭan you advice me which programming language I should focus on as a novice VBA programmer? There's so many, and a majority of them seem to have very different languages / syntax.

One thing before I begin, most of the languages are Object Orientated, it you don't know what that is, you might be best up reading up on it since it's probably going to be the biggest learning curve coming from Excel VBA.

#WHAT LANGUAGE CAN YOU USE WITH VISUAL BASIC FOR EXCEL CODE#.

What language can you use with visual basic for excel