Skip to Content
0
May 14, 2013 at 02:18 PM

EPMSaveData default value to populate database

36 Views

I am using the EPMSaveData function to store/refresh a cell "Growth Rate %." However, I would like the template do display a default value (2.5%) in this cell prior to the user's first save. Currently the function would return "0" as nothing has been populated in the database. We would like to save and refresh last input value, whether default or the user's input rate going forward.

We have considered doing a mass population of these fields,but I believe there should be a better way.

I have been playing with nesting the function and considering VBA solutions (on open or on change events), but have not yet resolved.

Any suggestions? Thanks