Hacker Newsnew | past | comments | ask | show | jobs | submitlogin
Best Way to Learn VBA for Excel
1 point by Ian999 on Jan 4, 2015 | hide | past | favorite | 5 comments
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!


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


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.


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


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




Consider applying for YC's Fall 2025 batch! Applications are open till Aug 4

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: