VBA stands for Visual BASIC for Applications. I currently am trying to learn it for use at my full time job on a PC to automate some tasks in Excel.
I used to be VERY knowledgeable about Excel macros, commonly called “Excel 4 macros.” I even contracted to do custom spreadsheets for several businesses and produced a few of those with macros to automate the process.
But in Excel 5.0, Microsoft started phasing out that Macro language and introduced VBA.
I no longer needed to do the macros, especially since normal uses of new functions in Excel, such as Pivot Tables, Text to Tabs and others helped remove the need to do some of them.
Now I am looking at learning VBA and have come across the following web sites that appear to be useful to learning it.
http://www.mvps.org/dmcritchie/excel/getstarted.htm
http://www.cpearson.com/excel.htm
http://j-walk.com/ss/excel/index.htm
If you know of other sites that will help me learn, please let me know at the link below.
BTW – Microsoft has said that the NEXT version of Office for the Mac will have VBA restored. So you can get an leg up on that if you start now. (I don’t expect an update before 2010 and probably not before 2011.
TIA
