I would also check out the Rubberduck VBA blog. Rubberduck is an add-in for the VBA Editor, but the maintainer, Mat, often writes about how to write clean and maintainable VBA.
I don’t work with VBA anymore, so I haven’t written about it in a while, but learning it (and subsequently C# for Rubberduck) is what launched my career in software. Good luck!
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Chip Pearson’s site is one of the best resources on the web for learning VBA. Chip (RIP) taught several generations of us how to code.
cpearson.com/Excel/MainPage.aspx
VBA4All is also a great resource, but you’ll unfortunately need to use the internet archive version.
web.archive.org/web/20140913092220...
I would also check out the Rubberduck VBA blog. Rubberduck is an add-in for the VBA Editor, but the maintainer, Mat, often writes about how to write clean and maintainable VBA.
rubberduckvba.wordpress.com/
Lastly, I’d recommend reading my older blog posts, back from when I was still working with VBA and helping Mat build Rubberduck.
christopherjmcclellan.wordpress.com/
I don’t work with VBA anymore, so I haven’t written about it in a while, but learning it (and subsequently C# for Rubberduck) is what launched my career in software. Good luck!