5 ms·

Might be irrevelant but anyone know best source to learn VB macros?

shamney 12y ago
excel 2007 vba programmers reference
nissimk 12y ago
If you are trying to automate some actions in the UI, use the record macro functionality and then edit the code. You can usually remove or combine a lot of the code it recorded. 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.
bmccormack 12y ago
My favorite reference is the VBA Developer's Handbook by Getz & Gilbert from 2001. 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.
agumonkey 12y ago
When I had to spend a large amount of intimate time with VBA I used to go to http://www.cpearson.com/Excel/Topic.aspx http://www.cpearson.com/Excel/Topic.aspx http://www.ozgrid.com/VBA/ http://www.ozgrid.com/VBA/ Old websites but in my case I dealt with Office <= 2003
- medell 12y ago
  Great recommendations, these two sites are still the best today. Ozgrid is my go to forum, the community there is top notch.
  - agumonkey 12y ago
    I'm still not sure there's another skywalker. I stopped [ab]using VBA in 2012 and unfortunately I can't recall the name yet.
NearAP 12y ago
Years ago, I used Microsoft MSDN anytime I had questions relating to VBA.
pessimizer 12y ago
Speaking specifically about Excel, the most important thing to learn is the Range object, no matter what book you're using: http://msdn.microsoft.com/en-us/library/office/ff838238%28v=office.15%29.aspx 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 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.
jwe 12y ago
If you have any specific questions about VBA feel free to contact me. I spent a couple of years on macros in various contexts and still have loads of links. (I second the links already posted)

excel 2007 vba programmers reference

If you are trying to automate some actions in the UI, use the record macro functionality and then edit the code. You can usually remove or combine a lot of the code it recorded. 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.

bmccormack 12y ago

My favorite reference is the VBA Developer's Handbook by Getz & Gilbert from 2001. 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.

agumonkey 12y ago

When I had to spend a large amount of intimate time with VBA I used to go to http://www.cpearson.com/Excel/Topic.aspx http://www.cpearson.com/Excel/Topic.aspx http://www.ozgrid.com/VBA/ http://www.ozgrid.com/VBA/ Old websites but in my case I dealt with Office <= 2003

medell 12y ago
Great recommendations, these two sites are still the best today. Ozgrid is my go to forum, the community there is top notch.
- agumonkey 12y ago
  I'm still not sure there's another skywalker. I stopped [ab]using VBA in 2012 and unfortunately I can't recall the name yet.

NearAP 12y ago

Years ago, I used Microsoft MSDN anytime I had questions relating to VBA.

pessimizer 12y ago

Speaking specifically about Excel, the most important thing to learn is the Range object, no matter what book you're using: http://msdn.microsoft.com/en-us/library/office/ff838238%28v=office.15%29.aspx 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 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.

jwe 12y ago

If you have any specific questions about VBA feel free to contact me. I spent a couple of years on macros in various contexts and still have loads of links. (I second the links already posted)