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.

 

[SeniorNewbie]

@Admin: I offered a help to Jens this board doesn't allow: To attach some pdf files. Do you really think, that removing a little hint against spam as helpful??

 

[Joe4]

We have never allowed attachments here. The reasons have been covered in details over the years (you can do a search if you want to dig up those articles and read about those).

You have the following options:
1. Post excerpts of your spreadsheets using the tool mentioned here: XL2BB - Excel Range to BBCode
2. Post screen print images of your spreadsheet
3. Upload your file to a file sharing site and post links to it in the post

 

[SeniorNewbie]

1 to 3 are no really news for me, but the experience that mrXl has very strict rules without a need. I holding an own forum and there registered members can attach any kind of office files, zip, txt, rtf, pdf, pic and even mp3/4 without any third party tools or servers. And if members want to communicate by private messages nobody can see - they're allowed to.

 

[Joe4]

1 to 3 are no really news for me, but the experience that mrXl has very strict rules without a need. I holding an own forum and there registered members can attach any kind of office files, zip, txt, rtf, pdf, pic and even mp3/4 without any third party tools or servers. And if members want to communicate by private messages nobody can see - they're allowed to.

That is great, you can choose to run your forum any way that you want to, just as MrExcel can run his forum any way he wants to.
It is not an arbitrary decision. It has been discussed many times over the years. If you are really interested in understanding why, you can search for those old conversations in the "About This Board" forum.