And, if they could create a plugin that allowed Libre Office to do the same, they could solve one of the last remaining major interoperability issues with LO and Excel: the inability to run VB macros in LO. That would be huge.
It's a shame, having a simple python scripting system built into Calc would be a major advantage.
http://msdn.microsoft.com/en-us/library/office/ff838238%28v=...
Close behind are Collections and UDTs. The best thing to level up after you're comfortable is with 'Implements' for interfaces.
I found that search engines are as good as any book for this stuff. It's smeared all over the internet.
The best place I know of to get a good understanding is http://www.cpearson.com/excel/MainPage.aspx, but it's not a tutorial.
edit: that's what I get for keeping this window open too long:) That's 2 votes for cpearson.com.
If you want to use dictionaries/hashtable there is a reference you can add called scripting.dictionary.
When you search google for how to do stuff in VBA, most of the best answers are in Ozgrid and MrExcel sites, and of course StackOverflow.
http://www.cpearson.com/Excel/Topic.aspx
Old websites but in my case I dealt with Office <= 2003
You can probably learn everything you need from Googling for solutions to problems, but that book was great when I was committed to working with Excel and Access for a while. It covers a lot of things you're not going to think to search about.