I need to learn advanced Excel (especially VBA) which books should I look for?

[The Swede]

I am starting a new job within Finance in a few weeks where they have hinted that I need some VBA skills. I will be creating some models for them which need to be robust, secure and so on. My knowledge of Excel is intermediate but I have never used VBA.

Can anyone recommend some good books I can pick up? I was looking in a bookstore today but there are tons of books which all look the same (huge and expensive). Online resources would also be great, or tips in general.

 

[Valor]

Do you know how to code in a real language?

 

[dusty]

I don't know if this will help you, but when I needed to learn some VBA I started by recording macros and then examining/editing the code they created.

 

[The Swede]

Originally Posted by Valor

Do you know how to code in a real language?
No, my coding skills are pretty weak. I have done some work in Stata but would not consider myself proficient in any way.

 

[TieMyShoe]

google searching is a great way to start...

 

[dragon8]

Try Video Professor

 

[Blackhood]

VBA for dummies is useless, but I found VBA In Easy Steps got me through my A Levels with good enough grades.