Book to learn Excel VBA?

LarryJ

Board Regular
Joined
Mar 25, 2002
Messages
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
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
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
 
Upvote 0
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
 
Upvote 0
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)
 
Upvote 0
I teach from Reed Jacobson's excellent book which is appropriate for XL97 thru 2002:
Excel 2000 Visual Basic for Applications Fundamentals
 
Upvote 0
Great recommendations guys!

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

Thanks!
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,515
Messages
6,114,080
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top