VBA Practice?

ai1094

Board Regular
Joined
Aug 23, 2018
Messages
92
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!
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
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 !
 
Upvote 0
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 !
 
Upvote 0

Forum statistics

Threads
1,224,819
Messages
6,181,153
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top