I learned to write Excel VBA simply by recording macros on Excel, going through them line by line understanding what they were doing, I would then Google How To... with Excel VBA, and take examples given and try to add them to the recorded Macro's , lots of trial and error, but worked for me...