Subscribe to DSC Newsletter

Can someone recommend me some good website or book to learn Excel VBA?

thanks 

Views: 1836

Reply to This

Replies to This Discussion

If I can suggest something about it, I would start looking at this:

http://www.excel-easy.com/vba.html

and another compilation of good websites could be:

http://www.skilledup.com/articles/advanced-excel-vba-programming

Hope it helps,

Cheers, ... DR

You might also want to take a look at xlwings, which allows for a basic VBA module, provided by the developer, that connects to python scripts you write.

Todd

if you can think of algorithm of your macro and know the syntax already you can learn a lot just from recording macro and analyzing its code

Think it depends on your coding background what you are trying to do with VBA. If you have coded before in any language,

Thanks for recommendations.

The best would be a book like Excel Power Programming or Excel Dashboards by John Walkenbach. Anything by John Walkenbach... he's Mr. Spreadsheets!

Qamar: Follow Rick's suggestion. Walkenbach is the one to choose, not last because he supplies very useful code with the CD. I have all of his editions from Excel 95 on.

The book i recommend is this:

Professional-Excel-Development-Definitive-Applications/dp/0321508793

however this is a further step even to the mighty Walkenbach so i recommend to read its stuff first

as an online resource i would suggest:

http://www.appspro.com/Default.html

http://www.tutorialspoint.com/vba/index.htm

http://www.homeandlearn.org/index.html

I totally agree with Luca about Professional Excel Development (PED). After teaching a full (36 hours lecture + 12 hours of lab) course in Excel VBA I'd love to create a next-step course based on the stuff in PED. It's for people already familiar with VBA in Excel.

RSS

Videos

  • Add Videos
  • View All

Follow Us

© 2018   Data Science Central ®   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service