Book to learn Excel VBA?

LarryJ · Mar 27th, 2002, 12:24 PM

I am pretty good with VBA in Excel, but I have some friends that want to learn it. I have been teaching them but thought it would be good to have some suggested books, if there are any.

So, can anyone recommend any books to learn VBA in Excel?

TIA

keithkemble · Mar 27th, 2002, 12:56 PM

Larry,

There are a number of books available.
Best bet is to use Amazon, I have purchased a number of them. Try the reviews first to see if its what you want.

I like VBA for Microsoft Office 2000, Its big meaty and has a cd. All for £30 squid.

You could also try Office 97 annoyances.

Amazon do a lot of used books as well.
Superb value
kk

LarryJ · Mar 27th, 2002, 01:03 PM

Amazon was my first stop, I use them for everything.

But my search for "learn excel vba" came up with a book that was panned in the recommendations. So I thought I would query this group too.

I'll look at the book you recommend too.

Thanks

Mark O'Brien · Mar 27th, 2002, 03:12 PM

I recommend Wrox press books. Especially if Stephen Bullen has owt to do with them.

I see Bill has recommended the Excel 2002 VBA. (except I used the XL 2000 version)

http://www.mrexcel.com/book.shtml

Additionally, slap in a search for Bill Jelen in amazon.com. (This site's founder)

Bob Umlas · Mar 27th, 2002, 07:19 PM

I teach from Reed Jacobson's excellent book which is appropriate for XL97 thru 2002:
Excel 2000 Visual Basic for Applications Fundamentals

LarryJ · Mar 28th, 2002, 06:45 AM

Great recommendations guys!

Since it turns out that I will now be teaching an actual class, these will really be helpful.

Thanks!

daveray · Mar 28th, 2002, 06:49 AM

Reed Jacobson also has a good book called

"EXCEL 2002 VISUAL BASIC FOR APPLICATIONS STEP BY STEP"

ISBN 0-7356-1359-1

You can get a similar version of the book for earlier versions of Excel.

I find it very helpful.

Dave

[ This Message was edited by: daveray on 2002-03-28 05:50 ]

Mar 27th, 2002, 03:12 PM	#4
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	I recommend Wrox press books. Especially if Stephen Bullen has owt to do with them. I see Bill has recommended the Excel 2002 VBA. (except I used the XL 2000 version) http://www.mrexcel.com/book.shtml Additionally, slap in a search for Bill Jelen in amazon.com. (This site's founder) __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

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

Mar 27th, 2002, 12:24 PM	#1
LarryJ Board Regular Join Date: Mar 2002 Location: Houston, TX Posts: 60	I am pretty good with VBA in Excel, but I have some friends that want to learn it. I have been teaching them but thought it would be good to have some suggested books, if there are any. So, can anyone recommend any books to learn VBA in Excel? TIA

Mar 27th, 2002, 12:56 PM	#2
keithkemble Board Regular Join Date: Feb 2002 Location: Leicestershire, U K Posts: 157	Larry, There are a number of books available. Best bet is to use Amazon, I have purchased a number of them. Try the reviews first to see if its what you want. I like VBA for Microsoft Office 2000, Its big meaty and has a cd. All for £30 squid. You could also try Office 97 annoyances. Amazon do a lot of used books as well. Superb value kk

Mar 27th, 2002, 01:03 PM	#3
LarryJ Board Regular Join Date: Mar 2002 Location: Houston, TX Posts: 60	Amazon was my first stop, I use them for everything. But my search for "learn excel vba" came up with a book that was panned in the recommendations. So I thought I would query this group too. I'll look at the book you recommend too. Thanks

Mar 27th, 2002, 07:19 PM	#5
Bob Umlas Board Regular Join Date: Mar 2002 Location: New York Posts: 71	I teach from Reed Jacobson's excellent book which is appropriate for XL97 thru 2002: Excel 2000 Visual Basic for Applications Fundamentals

Mar 28th, 2002, 06:45 AM	#6
LarryJ Board Regular Join Date: Mar 2002 Location: Houston, TX Posts: 60	Great recommendations guys! Since it turns out that I will now be teaching an actual class, these will really be helpful. Thanks!

Mar 28th, 2002, 06:49 AM	#7
daveray New Member Join Date: Mar 2002 Posts: 28	Reed Jacobson also has a good book called "EXCEL 2002 VISUAL BASIC FOR APPLICATIONS STEP BY STEP" ISBN 0-7356-1359-1 You can get a similar version of the book for earlier versions of Excel. I find it very helpful. Dave [ This Message was edited by: daveray on 2002-03-28 05:50 ]