A few people who program for major companies also publish code snippets. Studying these is a great way to learn.
Before you do this I would spend a day or so just learning some good habits it will pay off later.
e.g.
Why you should always declare variables (even though vba works without)
Why you should use the correct type of variable (again even though vba is very forgiving about this)
Why a naming convention for variables is a great idea.
Some good places to study code
Our site
Steve Rindsberg's PPTFAQ
Shyam Pillai (usually more complex stuff)
There are more but there's lots to study there