Books on Visual Basic for Excel ONLY.. Please help

[krayziez]

Hey,

I do alot of macros for Excel and have been pretty good at it, but I can only do it with the record macros command under Excel. I tend to copy and paste lines of codes to make it do other basic things so I know I'm a complete newbie when it comes to coding.

I want to find out a way to learn basic programming JUST FOR EXCEL. I don't want to go too hardcore with it either. I've tried to buy books on it but never really had the time to learn everything. I just want to specialize in Excel's macro programming and need a good reference to learn. Most books on amazon deal with All of VB. I just want an easy book on just Excel part of VB... I know I won't have the motivation to go through programming stuff that doesn't relate to what I want to learn exactly--EXCEL only... Any suggestions would be greatly appreciated!

also, should it matter too much whether its .net or pre-.net?

[adBSTRD]

The subset of VB is called VBA - "Visual Basic for Applicatons". Here are some books i found on it but it wont hurt to have a more solid background on VB6. You can also find plenty of documentation on VBA online.


Excel 2002 Power Programming with VBA

Microsoft Excel 2002 Visual Basic for Applications Step by Step

Excel 2002 VBA: Programmers Reference
Writing Excel Macros with VBA, 2nd Edition

[krayziez]

For these books, can I just use the built in VB that Excel 2002 has? Or do I need a full fledged VB .net or VB6? Sorry for the newbie questions, and thanks for the great help!

[daveshack]

The VB that is build into Excel is VBA - Visual Basic for Applications. If you have Excel you can use it.

I found the Excel 2002 Power Programming to be an excellent resource.. John Walkenbach or something like that I think

Anyway, good luck with it