How to learn VBA coding

[Mangosteenlu]

Dear All,

My job involves a lot of manual work which I would like to use VBA code to improve the efficiency. But I have zero knowledge of it. Can someone shine some light on how to learn VBA from scratch? any resources or your tube channel, who do you recommend? thanks in advance.

 

[Legacy 143009]

Excel Macro Mastery is a very good channel indeed.

 

[Mangosteenlu]

Excel Macro Mastery is a very good channel indeed.

Thank you Flashbond. I'll definitely give a go.

 

[Automatrix]

You may also benefit from looking into Power Query. It can do many similar things, and is much easier to learn.

 

[Joe4]

There are also very good books written by the MrExcel team which you can find in the Publishing section of the site: Products

 

[ceasar47]

Dear All,

My job involves a lot of manual work which I would like to use VBA code to improve the efficiency. But I have zero knowledge of it. Can someone shine some light on how to learn VBA from scratch? any resources or your tube channel, who do you recommend? thanks in advance.

You need to start exploring manual works to automate in small solver. Google the vba which you are looking for and run it. Also don't forget to post your queries here in the relevant thread sections..

All the best

 

[Jens Wang]

Excel Macro Mastery is a very good channel indeed.

How can I see it? From YouTube?

 

[SeniorNewbie]

Ok Jens - with your last question I learned that you first have to learn to google. Try Excel Macro Mastery in your favorite search engine and you'll become happy. May be
Mangosteenlu can help you already, if it's not successful...

 

[Jens Wang]

Ok Jens - with your last question I learned that you first have to learn to google. Try Excel Macro Mastery in your favorite search engine and you'll become happy. May be
Mangosteenlu can help you already, if it's not successful..thanks for your response.however,I cannot access to the google in our local since there is some policy. Could you send me with some eBook like Pdf? Jens_wang@yeah net

Appreciate your help.

 

[SeniorNewbie]

Although I don't know why, but it's here not allowed to upload PDFs.