Recommendations for VBA learning

zinah

Active Member
Joined
Nov 28, 2018
Messages
368
Office Version
  1. 365
Platform
  1. Windows
Hi,
I'm wondering if anyone in this forum can recommend websites or forums that have excel VBA training, I want to start from basics to advanced levels. Any recommendation please?
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
I did, but wanted to know from the members here since there are lots of experts in this forum and wanted them to share their advises and recommendations.
 
Upvote 0
Ah I see.

To be honest, I had spent 100's of bucks on excel workbooks, but the most valuable excel VBA book was "Excel VBA for Dummy's" By Jwalk

As far as learning excel on your own, commit to an excel help forum and start answering question, you will end up with a ton of bookmarks to excel sites, ton's of excel workbook samples and a library of codes saved for future use.

One of the main issues when first learning excel is having an idea and not knowing what it is called,
so you don't know what to search for that is definitely a benefit of excel forums.

Yes, answering forum questions is the best way I had learned.

Here are a few of my goto links
when I was first learning about macros
As far as videos go, I believe this girl is a terrific demonstrator.
And of course Mr.Excel himself
 
Last edited:
Upvote 0
You can have a look at the VBA suggestions in the list Hiker95 kindly provided in the link below to see if you find anything of use...

Hiker95's list
 
Upvote 0
Wow! thank you so much @davesexcel for sharing these links, the good thing I know the complicated formulas and some tricks but I started the macro journey like less than a year with some help from forums and this valuable forum, I'm going to follow your advises and I can learn as I did with Excel formulas.
 
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