I'm not a pro programmer and started my VBA in humble beginnings. I
asked lots, but I found a few readings very important to start with.

I foond the MSDN and support.microsoft articles to be understandable,
for the most part, but then I've seen lots of code.

I have hundreds of bookmarks for VBA.

Here's good ones for Variable Scope and lifetime:
http://support.microsoft.com/kb/141693

msdn2.microsoft.com/en-us/library/ms880451.aspx

THe % and all others are explained here.
Variables:
http://www.beyondtechnology.com/vba008.shtml