PDA

View Full Version : Want to learn excel VBA



Anshu
08-15-2020, 11:05 PM
Hello All!
I'm a beginner and completely new in the field of excel and VBA. But fascinated with the VBA, and due to my professional need, I really eager to learn Excel VBA from beginning. At least I must learn the basics of VBA. But I don't know how can I, and from where can I learn. Can anyone suggest me the sites or tutorial, where I can learn VBA, at least basics.

Logit
08-16-2020, 06:20 AM
.
See attached :

DocAElstein
08-17-2020, 03:27 PM
When I was learning I got totally overwhelmed by the amount of tutorial stuff available

I think I would do two things.

_1) Practice! A lot.
But do it on something that is relevant for what you need, so as to help you keep your motivation.
Google lots of information at different places. There is an increasing amount of information and free tutorials, but not all is good, and even some of the very popular site have mistakes. So get a good spread of information and don’t believe any individual. The best people have got mistakes at their sites and they are afraid to admit it. ( Or the people are dead, and they are treated as Gods, so their mistakes never get corrected)

_2) Download some of the better Play lists available. Make yourself a full play list and let it run in the background whenever you have the time. That way you are not under pressure to learn and things will slowly fall into your mind.

These two were the best a few years back. But I have not researched recently
YourProgrammingNetwork https://www.youtube.com/watch?v=ABXPb0qnKUY&list=PLS7iHfqXNVhK3yzd_4XS5k4zsvnu2mkJC
WiseOwlTutorials https://www.youtube.com/watch?v=KHO5NIcZAc4&list=PLNIs-AWhQzckr8Dgmgb3akx_gFMnpxTN5

If you are interested in Tutorials in Hindi, then this guy might be worth a look at
Dinesh Kumar Takyar : https://www.youtube.com/c/Exceltrainingvideos/playlists
He does tutorials in English and Hindi

Another tip: I would try to standardise on Excel versions 2002-2013. Forget recent versions . They are getting worse and worse, as is Microsoft software generally.
I think the future or Microsoft isn’t. The future of Microsoft is in legacy use. Concentrate your efforts on keeping an older system stable and working.

Alan

Anshu
08-17-2020, 06:18 PM
Thank you for the honest guidance!