There are developpez.org with a lot of data on vb/vba. For everything specific to Solidworks, you have to rely on the help of the API available online and from time to time the macro recorder to train yourself.
Otherwise indeed do not hesitate to search just with the term vba because it has a lot of examples with Excel
Otherwise the one with whom I learned all the basics of Web programming and other the SiteDuZero aka Openclassroom https://openclassrooms.com/old-courses-pdf in the archive there is a very good course on VB.net his teaches a lot of things
Otherwise as Cyril says.f Macro recorder and research:)
A piece of advice is to take the time to comment on these codes, I know I don't do it enough and it's more complicated when you come back six months later on a macro that doesn't work anymore :/