VBA vs macro


Posted by espen on January 15, 2001 5:40 AM

What's the difference between VBA and macros? And where can I learn about VBA and how they are made?

espen



Posted by Rachel Rabinowitz on January 15, 2001 7:10 AM

VBA is the actual code (in truth, it's the code behind the macros you record). It's more flexible than macros when you write it straight - and it's also useful to edit the macros you write to be more flexible (not hardcoded columns, rows, etc). You can also pass parameters in VBA which you can't for straight macros. You can learn about it from most excel books you buy.