For the Excel macro wizzards - How did you learn?

[Noobette]

For a long time, I've been working in macros and doing my best to teach myself using the macros recorder and searching the internet for tutorials and help. More and more of my projects are starting to involve macros and I need to up my education on this. Currently, my code looks like a chimp banged it out on a keyboard with a banana. I need to get better. How did you get the level of VBA knowledge that you have? Besides these forums, can you recommend any other resources? Thank you.

 

[shg]

Books are good -- I like Walkenbach's Power Programming series.

Other than that,

1. Learn to debug: http://www.cpearson.com/excel/debug.htm

2. Keep on coding.

 

[Noobette]

Thank you shg, will do.

 

[Peter_SSs]

Another board member has put together this quite extensive list:
http://www.mrexcel.com/forum/showthread.php?t=572285

 

[Noobette]

Thank you Peter_SSs. Excellent list, I will search through this too.

 

[PCRIDE]

I don't know much but I was amazed that you could simply record a macro, perform what you want the code to do, then stop it and use bits of the code.

Just keep adding commands and it mostly works.