Best Way to Learn VBA for Excel

Posted by Ian999 on Sunday January 04, 2015 @01:10AM
from the self-post dept.

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!

( 5 comments | on HN )

Re:Best Way to Learn VBA for Excel by nanis on Sunday January 04, 2015 @02:52AM (#8833791)

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...

[ Parent | on HN ]

Re:Best Way to Learn VBA for Excel by kevin_morrill on Sunday January 04, 2015 @01:16AM (#8833585)

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

[ Parent | on HN ]

Re:Best Way to Learn VBA for Excel by Ian999 on Sunday January 04, 2015 @01:39AM (#8833620)

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

[ Parent | on HN ]

Re:Best Way to Learn VBA for Excel by caseyf7 on Sunday January 04, 2015 @03:28AM (#8833857)

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

[ Parent | on HN ]

Re:Best Way to Learn VBA for Excel by gotorazor on Sunday January 04, 2015 @01:53AM (#8833648)

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

[ Parent | on HN ]