Know any good VBA tutorials?
October 19, 2009 8:11 AM Subscribe
Can you reccommend VBA tutorials, particularly for MS Excel 2007?
I used to know a tad of VBA that I used in the context of Access databases. However, I need to program some macros to help analyze our search analytics reports. I am floundering a bit -- so I've decided I need to go back to basics and more throroughly learn VBA. I checked previous questions and either they addressed a specific issue or the links provided in the answers are now dead :( I did look at the granddaddy of Excel discussions on the Blue. From there I checked out the Excel Nexus and VB Users pages. Those will be great when I'm beyond the basics, but they not at a tutorial level. I've consulted Google but there are tons of returns and I'm not sure how to tell which are any good.
Thanks for any leads!
I used to know a tad of VBA that I used in the context of Access databases. However, I need to program some macros to help analyze our search analytics reports. I am floundering a bit -- so I've decided I need to go back to basics and more throroughly learn VBA. I checked previous questions and either they addressed a specific issue or the links provided in the answers are now dead :( I did look at the granddaddy of Excel discussions on the Blue. From there I checked out the Excel Nexus and VB Users pages. Those will be great when I'm beyond the basics, but they not at a tutorial level. I've consulted Google but there are tons of returns and I'm not sure how to tell which are any good.
Thanks for any leads!
This thread is closed to new comments.
http://spreadsheetpage.com/
http://www.contextures.com/tiptech.html
http://www.exceltip.com/
http://www.exceltip.com/st/Writing_Your_First_VBA_Function_in_Excel/631.html
My local Excel mentor sent me a bunch of pre-made code nuggets to use. If you memail me an address that will accept attachments, I can send them to you.
posted by Gorgik at 12:43 PM on October 19, 2009 [1 favorite]