Macro vs VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Could someone please explain when you would use a macro and when you would
use VBA? So far, I've accomplished everything I need to using VBA and can't
see why you would use macro's at all.

Thanks,

Dave
 
Not quite. There's no easy way to do the equivalent of the AutoKeys macro
using VBA.
 
All of my applications have a generic form events class which every form
instantiates in it's Open event procedure. That class sinks events that I
want to be handled the same way in every form, which could easily include
KeyDown.
 
The only macro in any of my apps is AutoExec, which simply calls a VBA
procedure which opens the startup form while doing other housekeeping
chores, etc.
Even that little bit could be easily worked around as long as you were 100%
sure you would never, ever, ever forget to set your Startup form (six, meet
half-dozen). A matter of personal preference (no code behind my startup
form)

Biggest drawback to macros: no error handling.
2nd biggest: VBA more robust

HTH,
 
Back
Top