VB.NET and VBA are two very different entities. One is a robust fully object orientated business language, the second support automation and limited programming functions in business applications (and is used to write parts of the Office suite and other microsoft business apps).
VBA syntax is very similar to VB 5.0 and 6.0, but again VB 6.0 is separate entity as well.
Is it Visual Basic for Applications or VB 6.0 or VB.NET that you want a good book on?
I find the Learn in 24 Hours series excellent. Stay away from the complete references until you're familiar with the language, or are familiar with programming concepts.
As a beginner to program you will want a book that spends time on the basics of logic and structure as well as object orientated programming.