learning VBA

[is1ma1il]

I would like to learn some VBA, but will have to teach myself a little.

Does anyone have any suggestions?

Books

Web sites

etc....

Thanks for any help

 

[xlbo]

What program do you want to learn VBA for - they are similar but have different object models and properties. For excel, a good book is Power Programming by John Walkenbach but excel also has a VERY VERY powerful bit of kit called the macro recorder. (Tools / MAcros / Record New Macro). Turn it on, do something in excel (a copy and paste for example), turn it off, go look at the code - that's how I learnt
HTH
Geoff

 

[KyleS]

You're at one of the best places to learn. xlbo has a very good point, to learn some of the basics using the macro recordser is a good way to get started playing, and remember, you can record ANY action, from File:Open to anything else!

Creating a macro in Access and selecting File-->SaveAs and selecting "Save as Visule Basic" will convert your macro and give you an idea (although I'm not real big on alot of the methods it uses, it's still helps to see commands converted into VBA)

But this is an excelent place to learn, look through old posts and read the answers and if you don't see it, ask! Kyle