Are you looking to learn VBA (based on VB6), or the newer, .NET-based VB.NET? They're similar but also have crucial differences, so make sure to learn the one you'll be using.
Then you need VBA, not VB or VB.NET. VBA is the magic that makes Excel spreadsheets more powerful and last longer than it should. Many front desks are befuddled with the number of legacy spreadsheets that they can't live without.
I have the 2007 version of this book http://www.amazon.com/Excel-Power-Programming-Spreadsheets-Bookshelf/dp/0470475358/
I haven't come across any. Probably because VBA is seen as something you can quickly get the hang off, then the rest is just a lot of trickery and mastery that comes after years of using.
The often advice is to use the Macro function, record the action and look at the code.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.