VBA and Macros for Microsoft Excel

[brandonrlz]

Does this cover VBA and Macros in general? In other words, the items outlined in the material can be used for both 2010 & 2013 of Excel?

 

[starl]

There are some major object changes between 2010 and 2013. For example, charts were completely redesigned. So for specifics like that, you should reference the proper version. But for teaching the basics of programing (With.. End With, Select Case, setting objects, dealing with ranges etc) any version will do. If you have a 2010 version and need to code for 2013, you can always try recording to learn the required properties, methods or look up information in the Help.

 

[brandonrlz]

There are some major object changes between 2010 and 2013. For example, charts were completely redesigned. So for specifics like that, you should reference the proper version. But for teaching the basics of programing (With.. End With, Select Case, setting objects, dealing with ranges etc) any version will do. If you have a 2010 version and need to code for 2013, you can always try recording to learn the required properties, methods or look up information in the Help.

Thanks for the response. I didn't see any particular version specific material. I'm basically just wanting it to learn the basics behind VBA and Macros so that I can really take advantage of Excel. Would you suggest this as a starting point for VBA?

 

[starl]

Yes, any version will well cover the basics of VBA. There's a (short) chapter in each book that briefly discusses the differences (objects) between that book's version and previous versions.

 

[brandonrlz]

Awesome, thanks! Book purchased!