Gaining a moderate understanding of Visual Basic is an important goal for this course. However, I’ve not assigned a textbook to work from. There are many, many books on the subject and Amazon would be delighted to sell them to you. However, I think there is something a little strange about learning how to program from a book, especially because there are so many good online resources and examples Visual Basic scripts.
Here are a few that I think are worth spending time reviewing:
A site called Excel Easy also has a simple primer that I think is worth reviewing.
A more detailed step by step view can be found at excel-vba.com
Microsoft has a primer as well, which is now a few years old, but still pretty decent.
And if you don’t like any of these, there’s always YouTube. This channel called ExcelVBAIsFun seems to be pretty decent. I’d start with the first video.