Newbie to VBA and Macros in Excel

[jerrymoon1]

Any suggestions to good books or websites that can help me learn VBA and Macros in Excel? I think my skills are good in Excel, just want to learn how to use VBA and Macros.

Thanks

 

[davesexcel]

Any suggestions to good books or websites that can help me learn VBA and Macros in Excel? I think my skills are good in Excel, just want to learn how to use VBA and Macros.

Thanks

I think you just found one...

Here's others

http://www.cpearson.com/excel/topic.htm
http://www.mvps.org/dmcritchie/excel/search.htm#sitesearch
http://www.contextures.com/tiptech.html
http://www.andrewsexceltips.com/my_tips.htm
http://j-walk.com/ss/excel/index.htm

that should be a good start
:wink:

 

[northwolves]

Current site .

And the helpfile is helpful.

Best Regards

 

[Joe Was]

Check out the "Online Store" link above.

We have posted many links to Free tutorials on the net, so a search, using the search tool!

I think using this board to look-up questions that have been answered and then to try them out and then to modify them to make the sample do different things and to improve upon them. Is the best way to learn. When you have a problem post the code, in a new post, and ask for help with the problem.

I have found courses to be too much of an overview that covers too many things that you will not use and then you come away confused. Stick to things that you can use and learn them first as new problems come from your investigations, look them up, play with it and ask questions when you get stuck.

 

[wardnine]

I had the same question last month and was in your situation (have strong Excel skills but know nothing about VBA). By far, the book that was most frequently recommended to me was John Walkenbach's Excel 2003 Power Programming with VBA so I bought that one. Haven't gotten that far into it so I can't offer an opinion on it but this book seems to be very well regarded as an excellent intro Excel VBA book.

As far as macros are concerned I can't help you there... don't know how much Walkenbach's book discusses macros.

 

[Tahir]

Hi
I have recently found some books on VBA for free download.

download VBA book for beginners from URL below

=>>http://www.oebook.com/{65574750-EC24-42C7-9A2E-5E6809C42FC0}.htm

you can brows www.oebook.com in office category for more books on VBA and Excel.

Regards.