Best Way to Learn VBA for Excel

#1

Post by Ian999 » Sun, Jan 04, 2015, 6:10 AM UTC

Did some Googling for learning VBA for Excel and didn't find any standout resources. I know some java and python. Anyone have any suggestions of resources they have found useful. Thank you!

Re: Best Way to Learn VBA for Excel

#2

Post by kevin_morrill » Sun, Jan 04, 2015, 6:16 AM UTC

Record Macros and inspect the code to learn the object model.

Re: Best Way to Learn VBA for Excel

#3

Post by Ian999 » Sun, Jan 04, 2015, 6:39 AM UTC

kevin_morrill wrote: post #2

Record Macros and inspect the code to learn the object model.

Thanks for the response. I'm looking for a more comprehensive way to learn it though.

Re: Best Way to Learn VBA for Excel

#4

Post by gotorazor » Sun, Jan 04, 2015, 6:53 AM UTC

Ditto. I cannot find a good source to learn VBA either.

Re: Best Way to Learn VBA for Excel

#5

Post by nanis » Sun, Jan 04, 2015, 7:52 AM UTC

Refer to Microsoft's reference:

http://msdn.microsoft.com/en-us/library/office/ee861528%28v=...

Also, use the Object Browser in the Macro Editor to browse the list of available objects, methods, and properties. If you need more information on a particular object, search MSDN. E.g.,

https://www.google.com/search?q=worksheet+object+site%3Amsdn...

Re: Best Way to Learn VBA for Excel

#6

Post by caseyf7 » Sun, Jan 04, 2015, 8:28 AM UTC

If you know Python, you may prefer xlwings to learning VBA.