When VB.net, C# and C++ were not part of the API, the help was much better. There are several websites that offer VBA/SW API programming classes. You can also search API help typing "example (vba)".
However, it does not help if you have no program experience. If you are going to use VBA, I recommend finding a good programming reference for VB6.0. Also try recording a few macros (although that does not always record items selected from the menu or property manager, and does not use the more efficient ways of declaring SolidWorks object variables).
I am self taught in programming both VB6.0, VBA and SW API so...
Thanks Artem. We also have written .NET guides on how to create addins and stand-alones that are extremely detailed for anyone who wants to understand the nuts and bolts of those kinds of programs.
Is CodeStack yours? That's pretty cool.