Hi saravanan1981,
Adding a Layman’s input / answers to some of your questions:
( _...._... I started as a complete computer idiot a couple of years ago ....
I learnt some basic computing 25 years ago, Pascal, Fortran, Basic etc..
I hit “OOP” ( Object Orientated Programming ) for the first time a couple of years ago..
The only course available to me was a short Night School Course titled "VB/ Programming/ OOP". It was a basic introduction to programming. It used Visual Basic 2010.
I found OOP weird, but got used to it....._....)
My first PC had Office including VBA. Naively I thought it was the same as VB. From the laymen’s viewpoint, I found the Forms Side of VB ( which I think is what you usually learn first in VB ) very similar to the UserForms in VBA.
_..................................
The actual coding I found, as a Beginner, very similar. The Basic OOP Programming course in VB that I took part in got me started in VBA ( I note that technically VBA is not a OOP language, ( many experts have told me this, as discussed in this Thread ) but for a Beginner, for all intents and purposes, it appears so )
_...................................
You will find that the Experts in this Forum range from very experienced professional programmers to people with no formal education in programming or in some case much education at all. It appears anyone can VBA !!
_...........................
Most people will tell you that practice and participations in Excel Forums is the best way. But also some you Tube Videos can be helpful:
http://www.excelforum.com/showthread...00#post4272300
If you attend any introduction course on programming that explains OOP and demonstrates basic coding techniques, such as looping, then that will get you started for both VBA or VB.
But I would keep in mind the important comments from the experts here, regarding the differences should you be considering a long term career in computing. Up until now, only very occasionally have things like VBA not being a true OOP language caused me a problem and frustrations. Mostly that was when delved a bit too deep for my abilities.
Thankfully , experts here were able to save me from drowning.
Alan
Bookmarks