VBA TUTORIALS

[jds422354]

I REALISE THAT THIS IS NOT SO MUCH AN ACTUAL PROBLEM MORE OF A REQUEST FOR ANY RECOMENDED PLACES WHERE I CAN DOWNLOAD FREE VBA TUTORIALS. I WANT TO START LEARNING MORE ABOUT VBA IN EXCEL. ANY GOOD LINKS WOULD BE APPRECIATED.

REGARDS
JAMES

 

[xlbo]

Pls don't use CAPS - it's the equivalent of shouting

IMHO the best way to learn VBA is to use the Tools>Macro>Record macro facility in excel and word

Turn it on, perform some actions and turn it off, then look at the code that has been produced. Normally, it'll have a lot more selects and scrolls etc than you will need but it's a good way to learn how excel operates

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes

 

[klmorgan]

Its not free but I found Micro Excel 97 Visual Basic Step by Step a good help and then suplimented by questions on this forum.

There are a number of one liners that people have sent that are great and I keep them in a ring binder for future reference.

I've bought some other good books and training CD's also but lack the time to really get my head around it.

Regards

Keith

 

[tazman99]

Hi jds422354,

Below is a tutorial that I found helpful, enjoy!

http://support.microsoft.com/default.aspx?scid=/support/excel/content/vba101/default.asp#modify

tazman

 

[Rick39]

Try

http://www.lacher.com/toc/tutvba1.htm

 

[TonyU]

One more:

http://www.exceltip.com/se/vba.html

[sup]

There's never time to do it right, but there's always time to do it over!
[/sup]

-TonyU