One thing to consider is whether the VBA code is causing updating of the front-end UI. If it is then with using triggers it will be difficult to duplicate the functionality. Code that runs when something changes isn't necessarily background in terms of what it might do to affect other information displayed on the screen. For instance if you are updating a YTD total that is displayed on the screen and it is important that the latest data is displayed - if you do VBA code that can happen when data on the screen changes but with triggers it isn't going to happen until the data is actually updated in the database.