The biggest pro of using VBA code over macros is that it allows for extreem powerful programming. It helps to build Access applications that are very versatile and fast. In my 30 years as VBA programmer I have done things that many IT-ers thought were impossible, until I proved them wrong. VBA gives the opportunity of building really smart functions/applications.