learning VBA for excel

chouston · Apr 25th, 2002, 12:30 PM

Visual Basic seems to be the answer to all of my problems. I have a little bit of programming experience and would like to buy a book on VBA so I can use it to automate and customize my excel spreadsheets. Can anyone recommend a good book? Thanks in advance for your replies!

Jay Petrulis · Apr 25th, 2002, 01:00 PM

Hi,

Any of the John Walkenbach books should be a good start. When you get more advanced, you can start on the John Green/Stephen Bullen VBA texts.

For a more complete list of books available, try: http://www.contextures.on.ca/tiptech.html

If you want online tutorials, try one of these:
http://www.microsoft.com/officedev/a.../toc/pgtoc.htm

http://msdn.microsoft.com/library/de...mmersguide.asp

http://www.microsoft.com/exceldev/e-a&sa.htm#vba

Also, don't forget the Newsgroups!!!! You will learn a ton here at Mr. Excel and others.

For websites, the first places to go are John W's, David McRitchie's and Chip Pearson's:
http://www.j-walk.com/ss/
http://www.mvps.org/dmcritchie/excel/excel.htm
http://www.cpearson.com

I would also recommend browsing through the MrExcel site!

HTH,
Jay

chouston · Apr 25th, 2002, 01:14 PM

Thank you, that was very helpful. I'll be an expert by tonight

Jack in the UK · Apr 25th, 2002, 01:36 PM

my call is free lurck this site and be ready to listen, this site is rich in all and more ....no better

Jay Petrulis · Apr 25th, 2002, 01:49 PM

Hi,

I forgot one. One of the most frequent posters to Mr. Excel is Dave Hawley. His site is very nice, too.

http://www.microsoftexceltraining.com/

Apr 25th, 2002, 01:36 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	my call is free lurck this site and be ready to listen, this site is rich in all and more ....no better __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 25th, 2002, 12:30 PM	#1
chouston Board Regular Join Date: Apr 2002 Location: Arizona Posts: 68	Visual Basic seems to be the answer to all of my problems. I have a little bit of programming experience and would like to buy a book on VBA so I can use it to automate and customize my excel spreadsheets. Can anyone recommend a good book? Thanks in advance for your replies!

Apr 25th, 2002, 01:00 PM	#2
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, Any of the John Walkenbach books should be a good start. When you get more advanced, you can start on the John Green/Stephen Bullen VBA texts. For a more complete list of books available, try: http://www.contextures.on.ca/tiptech.html If you want online tutorials, try one of these: http://www.microsoft.com/officedev/a.../toc/pgtoc.htm http://msdn.microsoft.com/library/de...mmersguide.asp http://www.microsoft.com/exceldev/e-a&sa.htm#vba Also, don't forget the Newsgroups!!!! You will learn a ton here at Mr. Excel and others. For websites, the first places to go are John W's, David McRitchie's and Chip Pearson's: http://www.j-walk.com/ss/ http://www.mvps.org/dmcritchie/excel/excel.htm http://www.cpearson.com I would also recommend browsing through the MrExcel site! HTH, Jay

Apr 25th, 2002, 01:14 PM	#3
chouston Board Regular Join Date: Apr 2002 Location: Arizona Posts: 68	Thank you, that was very helpful. I'll be an expert by tonight

Apr 25th, 2002, 01:49 PM	#5
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, I forgot one. One of the most frequent posters to Mr. Excel is Dave Hawley. His site is very nice, too. http://www.microsoftexceltraining.com/