Learning VBA for Excel

1)VBA for dummies

and the other one I cant remember the exact name of, but it's Microsoft Press and is called something like

2)VBA Fundementals in Excel

The first of those does cover Excel XP, but the second is specifically for Excel 2000. I presume there now is an XP version?

Also, I have got a great deal of help from click here

And finally, I learnt a lot by recording macros and then studying the code generated. (Tools>Macro>Macros>Edit).

Good luck,

Regards,

Simsy

Try 'Excel 2000 VBA Programmers Refference' from Wrox. I found it very usefull un the past. Also, as Simsy says, the best way to learn is to record macros, then look at the code that it produces.

Thanks for your suggestions. For anybody else trying to learn, studying the macro is a good idea. The little bit of VBA that I do know was obtained by doing exactly that. I used to do simple programming with Basic on Atari & Sinclair computers, so hopefully it won't be a steep learning curve.

Be a bit Beware. They went bust and there is great difficulty in getting any support or help if things don't go perfectly.

Some books were taken over by Apress and the others taken over by Wiley. Both have 'help rooms' but life can be difficult in the suuport area. Might be worth a look at both sites to see if there have been many 'complaints'.

I found this out (the hard way) after I bought Access 2002 VBA where there is quite a problem with the most important chapter in the book.

However, the up side is that I have been learning a lot from their book.

Chris

My personal favourite is click here It is like an electronic book that hou read as Help files in Excel. You can copy and paste the examples. There is other good stuff on that site as well.

Something free from Microsoft! click here

Also

click here

click here

click here

click here

click here (turn off speakers)

click here

click here

click here

click here

click here

click here

click here

and finally click here

Good luck. You know where to come when you have questions.

Impressive set of links VoG, i'll put this in "My Postings" for future reference.

Thanks everyone. Off to work now so I'll be perusing through your many links over the weekend, VoG.

I've bought "Excel VBA Programming 'for the absolute beginner'" by Duane Birnbaum (in my price range). Slowly looking through VoG's very helpful links.

Thanks for your input everyone :O)