VB & VBA in a Nutshell by O'Reilly gives good coverage of VBA only and the now obsolete VB6. Useful for its summary of 'gotchas'.

I take it you are aware that in the VBA IDE pressing F1 on anykeyword brings up the MS help on that item.