VBA Practice?

ai1094

Board Regular
Joined
Aug 23, 2018
Messages
84
Hi all, I find myself always posting on the forums and asking for assistance with VBA. Majority of the times I get the help I need which is great, but usually have a hard time understanding what the code actually does/means. I would say I'm an advanced Excel user but still a beginner with VBA. I know how to record macros and slightly enhance the code if needed.

So this question goes out to my VBA gurus: Where is a good place to start WRITING my own VBA code? Recording macros is great and all, but I want to learn how to actually write my own so I can make my macro more efficient and eliminate any extra lines of code if necessary.

Would love to hear everyone's suggestion. Thanks!
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

mse330

Well-known Member
Joined
Oct 18, 2007
Messages
652
Office Version
365
Platform
Windows
The below link is good to take you from the very first steps in VBA
https://www.homeandlearn.org/

Once you have the basic fundamentals of VBA, the below link is one of my favorites
https://excelmacromastery.com/vba-articles/

Also, I have gained a lot of understanding by browsing Mr. Excel forums & seeing how the members solve other peoples' problems. It is really fun especially once you could understand the potential of it & how it could make your work easier/more efficient !
 

ai1094

Board Regular
Joined
Aug 23, 2018
Messages
84
Thanks for the suggestions!

The below link is good to take you from the very first steps in VBA
https://www.homeandlearn.org/

Once you have the basic fundamentals of VBA, the below link is one of my favorites
https://excelmacromastery.com/vba-articles/

Also, I have gained a lot of understanding by browsing Mr. Excel forums & seeing how the members solve other peoples' problems. It is really fun especially once you could understand the potential of it & how it could make your work easier/more efficient !
 

Watch MrExcel Video

Forum statistics

Threads
1,099,897
Messages
5,471,365
Members
406,758
Latest member
Antsnetswprk

This Week's Hot Topics

Top