Help/Advice

[moremeba]

Can anyone suggest any good websites to learn vba for a beginner? In particular VBA for Excel

Thanks in advance

Barry

 

[dyarwood]

best thing I could suggest is try the macro recorder with some everyday things you would do and then look at the code. From there you can get a good start

 

[fumei]

I agree. Make a separate file with a worksheet in which you start collecting code. Record things and look at the code; see things here or on other forums, copy the code. Store everything into the one file. Comment everything you do....even little steps. Comment everything[/b[, step by step as you learn what each line does. It may seem tedious at first, but it will be a huge help in your learning process.

Record and comment.

Gerry

 

[moremeba]

Thanks to both of you for your replys!
I will give both of these metods a try.

Thanks again

Barry

 

[Fherrera]

Here are just a few places that offer some ideas on how to use Excel in VBA, lots of good examples as well. My searches usually ended up leading me to these places and then I stuck around and read about other solutions I may have required later.

http://www.exceltip.com/

http://www.cpearson.com/excel.htm

http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm

For not so hard questions, I usually just google "excel vba ____" and usually find some help.

This forum is great for asking more complicated questions...
Don't forget about the keyword search as well.

Frank