EXCEL 2000 Bible (Bible S.) Book | John Walkenbach

[bsnapool]

Is this a good book to learn VBA????

 

[Richard Schollar]

Hi

I wouldn't have thought so given that it covers everything to do with Excel (not just VBA) so it might be a good starter, but won't provide sufficient depth. If you're after a *great* VBA starter, then i think John's other book Excel VBA Programming For Dummies is extremely hard to beat.

Richard

 

[bsnapool]

Quick question, How long did it take yourself to be sufficent ion writing code in VBA?

 

[Richard Schollar]

I dabbled for a couple of years without really being proficient and to be honest, it's only been in the last 21 months that I've been learning 'properly' if you like.

I do find it very difficult to just read a book and learn: I need to have a reason for doing so, which started off being development work here at my work. I thoroughly enjoy learning new stuff with VBA, so I guess the joy of discovery is now what's fuelling my learning.

Hope this goes some way to answering your question!

Richard

 

[bsnapool]

Yeah, thanks for your reply...

I have only just started out and would really like to expand my very basic knowledge, but I think it will take quite a bit of time for me to get to grips with it all..

Thanks

 

[Smitty]

My best advice, other than the books (Walkenbach's are great), would be to play with the macro recorder doing everyday repetitive tasks, then analyze the code and see what it does and why.

And learn to get rid of Select statements and screen navigation, which are probably the two most wasteful things that the recorder generates.

HTH,

Smitty

 

[bsnapool]

Thanks Smitty