VBA book for rookies?

krodriguez

Board Regular
Joined
Jul 11, 2012
Messages
119
Hi, new to VBA, and would like to have a book to guide me thru how to automate reports, etc... and how this VBA stuffs works in general.

Looking for material that can make sense to someone with zero VBA experience.

Thanks a lot!
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
I bought Excel 2010 Power Programming with VBA by John Walkenbach, and keep this on my desk for reference (it's petty good when I want to find a quick example for a new method/parameter i want to use)

I'm fairly new to VBA, but have come a long way (in my opinion) in the short time I've been using it (approx 6 months). I'm now in charge of automating a large majority of reports at work. The best resource I came across was a series of Youtube tutorials. Search 'WiseOwl Tutorials VBA'.

Theres a lot of content out there, but I think the best principal is to just pick any resource and start writing code :)
 
Last edited:
Upvote 0
VB and VBA in a nutshell was my bible.

Back in the 1990s, I was hired for a VBA position and didn't know word one of it. That book enabled me to perform very well at that position. It's very straight forward and to the point. I had zero VBA experience. Pick it up, it's worth it.
 
Upvote 0
Just a quick addition.....
Most people will say practice, practice and more practice, and participation is much better than a book or bookS

But MrExcel Member hiker95 keeps a very extensive list of general Excel learning material including BookS
http://www.mrexcel.com/forum/excel-...ng-visual-basic-applications.html#post4379195

And I would agree there are some good You Tube Play lists for VBA, which are a good second or third best in learning. Here is a list of play lists ( for VBA )in the order of usefulness i found when learning:
http://www.mrexcel.com/forum/excel-...ng-visual-basic-applications.html#post4379209

Alan
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,980
Messages
6,175,764
Members
452,668
Latest member
mrider123

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