![what language can you use with visual basic for excel what language can you use with visual basic for excel](https://peltiertech.com/Excel/pix6/SolverExample1.png)
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. 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. Java, Python, Visual Basic, Visual Basic.
![what language can you use with visual basic for excel what language can you use with visual basic for excel](https://www.techonthenet.com/excel/macros/images/visual_basic_editor2010_003.gif)
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. Perhaps to make some smaller executables that can handle updating reports on a weekly basis and things like that.
![what language can you use with visual basic for excel what language can you use with visual basic for excel](http://www.vb-helper.com/howto_net_read_excel.png)
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. 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).
#WHAT LANGUAGE CAN YOU USE WITH VISUAL BASIC FOR EXCEL CODE#
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. 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). First off I want to thank everyone on this forum for the quick, accurate and friendly replies to the threads that myself (and others of course) have started when we were stuck with VBA programming or otherwise ran into problems while using Excel.įor myself, I'm just a novice when it comes to programming in Excel VBA.