If you're talking about "VBA and Macros for Microsoft Excel" by Bill Jelen "Mr. Excel" and Tracy Syrstad, yes it will.
I would also recommend: "Excel VBA Programming for Dummies" by John Walkenbach. I'm not calling you a dummy - it's just a good starter book.