VBA self learning

[o.0]

Hey guys,

I've been using MS Excel for ages and have gotten to the stage where I've just about exhausted its gui interface. Recently I've reached the stage where the formulas I'm trying to input into the cells are deemed "too large." So I figured it was about time to learn VBA, specifically for MS Excel. To that end I'm planning on getting work to send me to a course early next year. However I was wanting to get stuck into it now, that way I can head off to a more advanced course when I eventually go.

Given that, I'm trying to teach myself VBA with the use of books/google. Just got back from the book shop with a copy of "Excel VBA 2003 - Programmer's Refernce." It seems to be a fairly comprehensive volume, but I'm worried I've thrown myself straight into the deep end with it. I should point out that I have very little programming experience - a couple of Matlab intensive courses at uni.

I've come here seeking some advice on a good way to get started on the whole thing, perhaps in the form of a good book or online tutorial system. I figure I should try my hardest to get my foundations right as it'll make it easier to build upon. So yeah if any one could point into the right direction I would be very grateful.

Cheers,

o.0

P.s. I should probably point out that I'm fairly good at logic statements (Maths background), so I can understand fairly un-elaborative text. Optimally I would like a book/tool with a lot of examples minus a ridiculous amount of jibber-jabber.

[esjay]

take the a of the end and CHUG CHUG CHUG CHUG senn.

maybe there is a tutorial on w3schools.com?

[bokCHOI]

Well... when I first used excel for the IT at school this year... I was really frustrated with the formulas and stuff. Coming from a VB background, instead of using half of excels stuff, I just did it in vba.

Its really simple though in excel with the help of dissecting macros.

With excel, you really don't need to know too much vba for that matter. VB is a very simple language and the most you will ever really need to know is basic logic and basic loops. The rest you make a macro in excel and go to the module and go through it ( making sure you made the macros with minimal movements ) and find out how it does it in vb.

Should first learn some simple VB ( not sure which version people around here will reccommend though, wait for key decoder or chem for that ) but they are all very similar and easy to learn.