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

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

mse330

Well-known Member
Joined
Oct 18, 2007
Messages
756
Office Version
  1. 365
Platform
  1. 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 !
 
Upvote 0

ai1094

Board Regular
Joined
Aug 23, 2018
Messages
92
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,187,074
Messages
5,961,425
Members
438,544
Latest member
DrDoyle

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
Top