wats the best way for learning Macros, vba's etc

[sokevin]

hi i am a newbie, and havent done any macros or programming in excel.

whats the best way for me to learn about vba, macros and stuff.

thanks :

 

[Nick Cranham]

sokevin,
Use the macro recorder, Tools > Macro > Record New Macro. Do you actions.
Stop the recorder an dexamine the code.

The local library will have numerous reference books on this.

NickHK

 

[Gord Dibben]

sokevin

David McRitchie's "Getting Started". Note links to other sites at the bottom
of the page.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

VBA Tutorial from Microsoft.

http://support.microsoft.com/support/excel/content/vba101/default.asp

There are many more, but these should get you going.

Don't forget the Macro Recorder. The code is not perfect, but you can get an
idea of what is happening.

Gord Dibben Excel MVP

 

[Tomek]

Buy a good book, that's how I started. It is also not a bad idea to read
something about programming in general - algorithms, programming technics
and stuff.