I am posting my course materials for Programming with Excel VBA (CS 106, Computing Fundamentals II) on this site. You are welcome to use them any way you like, but please acknowledge me if you copy them. If you want to take this course for credit, and are not currently a Portland State student, you can sign up as a non-admitted student at Portland State. If you just want to learn the material, please be aware that learning to program is like learning to ride a bicycle. You can read about it and watch someone else do it all you like, but until you actually try it yourself, you won't learn much. If you are currently enrolled, you will need to go to the D2L site to find the most recent versions of the worksheets and assignments.
This class focuses on teaching you the principles of programming. For the details of using Excel, you will need a reference book such as Excel 2010 Power Programming with VBA, or you can find plenty of resources on the Web. I have provided useful examples of what I think are the most common things that people want to do. My main goal is to help you learn to program. That's really the hard part. Once you do that, looking up the details is, well, a detail.
The course lectures are posted on YouTube on my channel, professorcindy. Comments and suggestions are welcome; please send them to professorcindy at gmail.com with subject line Excel. I am particularly interested in comments on what other topics should be covered and which current topics need more explanation.