Excel VBA

richardw

I know exel well, how easy is it to learn VBA for excel?

RichardJohn_2

VBA's not massively difficult, but how long it would take to learn would vary a lot based on your experience.
Do you have any experience with other programming languages (or knowledge of programming principles)?

richardw

RichardJohn wrote: »

Do you have any experience with other programming languages (or knowledge of programming principles)?

No, but am an experienced excel user and have a logical way of thinking, just want to become an excel expert.

isofa

If you have no programming experience you'll find it complex. Knowing Excel and knowing VBA are two very different things, knowing an application back to front and actually programming it with a language are not to be confused (but I'm not trying to put you off, just be realistic!)

However, if you are confident with programming and are used to other procedural languages (C, VB etc), then you won't have a problem. You also need some knowledge of programming constructs and principles.

VBA is surprisingly powerful I've written everything from financial to survey systems in Excel, amazing what can be achieved.

I'd suggest a good book from Amazon to start with.

richardw

Any suggestions to introduce myself to programming principles?

[Deleted User]

VBA is a pretty easy and straightforward language, if you want to learn then the Dummies! guides are usually a good starting place, ie

http://www.amazon.co.uk/Excel-VBA-Programming-Dummies/dp/0764574124/ref=sr_1_1?ie=UTF8&s=books&qid=1222427358&sr=1-1

isofa

richardw wrote: »

Any suggestions to introduce myself to programming principles?

Books from amazon! A starter on how to program in VBA would be ideal.

rmg1

If you want to borrow(?) an e-book, I have one that goes through both VBA and .NET principles.
I also have one which is more of a quick-start guide that runs to 4.5MB so the same problems of getting it across stands.
It's 25MB though so would probably have difficulty getting to you via e-mail unless someone has any ideas?

isofa

I'd say buy a book, you can read it at leisure, have it open and the computer whilst your try out exercises, but then I really hate ebooks and I love books! The best book, by far on Excel VBA is that by John Walkenbach, he is an expert, and although I've been writing financial apps in VBA for years, I still refer to it regularly - but this isn't for novices, try a getting started one first.

[Deleted User]

isofa wrote: »

I'd say buy a book, you can read it at leisure, have it open and the computer whilst your try out exercises, but then I really hate ebooks and I love books! The best book, by far on Excel VBA is that by John Walkenbach, he is an expert, and although I've been writing financial apps in VBA for years, I still refer to it regularly - but this isn't for novices, try a getting started one first.

I'm not a fan of ebooks either, I like having a book I can lay across my lap and refer too while seeing what I'm doing, plus you can have them either side too!

Gambler

I've bean meaning to go on a course for years now.