4 ms·
Best Way to Learn VBA for Excel
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!
- kevin_morrill 12y agoRecord Macros and inspect the code to learn the object model.
- Ian999 12y agoThanks for the response. I'm looking for a more comprehensive way to learn it though.
- gotorazor 12y agoDitto. I cannot find a good source to learn VBA either.
- nanis 12y agoRefer to Microsoft's reference: http://msdn.microsoft.com/en-us/library/office/ee861528%28v=office.15%29.aspx 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.microsoft.com https://www.google.com/search?q=worksheet+object+site%3Amsdn...
- caseyf7 12y agoIf you know Python, you may prefer xlwings to learning VBA.