last few weeks been doing more and more in the way of VBA to get Excel to do things. I know enough to know what i want to do, but not always the correct syntax or commands.

So far i have spent alot of time hunting round the internet and using google to figure out what i need to do to get what i want.

I was thinking about a slightly more structured approach, and either find a website that will tell me everything i need to know, or buy a book.

Any suggestions of a decent website and/or book that would help me learn.

I wish.
Im probably the same level as you. When I absolutely need to use VBA I just hunt and pick code from google searches until by some miracle a routine works 🙂

If you find a decent online teaching resource, do let me know coz I havent the foggiest how it works 🙂

http://www.homeandlearn.co.uk/NET/vbNet.html

I have been teaching myself with the help of this website – it may or may not be what you are looking for but its free.

I’ve always found Wrox books to be very good:

http://www.wrox.com/WileyCDA/WroxTitle/Excel-2002-VBA-Programmers-Reference.productCd-0764543717.html

There’s also one for Escel 2000, Excel 2003 and Excel 2007, depending on your preference… Must get around to reading my copy of the 2003 version sometime.

Or if Wrox turns out not to be your style:

http://www.amazon.com/s/ref=nb_ss_gw?url=search-alias%3Dstripbooks&field-keywords=excel+vba

You can also download the Visual Basic program directly from Microsoft for free.

http://www.microsoft.com/express/download/

I used this:

http://www.amazon.co.uk/Microsoft-Excel-Visual-Basic-Step/dp/1572313188/ref=sr_1_20?ie=UTF8&s=books&qid=1236368391&sr=8-20

It’s pretty much the ‘you know VBA and macros exist but need to know where to start putting it together’. It teaches some useful excel along the way. I don’t like pure excel books as they get too invlved in graphs / formatting etc and not enough in getting it to do stuff if you get what I mean.

I found myself quite adept at modifying programs written by others and this seems a good way to start as most of my requirements are a variation on some previous theme.

So, in these credit crunch times, surely someone should be putting together some training on this. My local college offered a 12 week course and I signed up but it got cancelled due to me bing the only interested person. I can think of 3 people out of 500 at my workplace that would pay for something out of their own money and I know I could justify it as high level excel training for 6-10 of us if a lealistic course existed

I’m trying to find a course to do this year.

However, in the meantime I just end up writing the little that I can, recording things and modifying to suit and also getting tips and tricks from the mrexcel site and forum:

Mr Excel

That has managed to get me as far as writing functions and macros to take a week long reporting process each month down to half an hour amongst other things.

Leaving me more time to w**k over bike parts.

I love writing stuff in excel vba. Similar situation to Scott, been automating complex reports for a company who are more used to doing it all manually. Saved them days of work each month. Sadly it seems I haven’t saved them enough time for them to renew my contract. Ho hum.
I’ve been a developer for years in other languages but really need to do a vba course as I’m self taught and probably missing some knowledge I’d need to get me a job elsewhere.

I edit or steal others code. Most programmers do