Bill,

If the formula is constant and the inputs are just that, inputs to the formula, then I would code it in a Function procedure in a general module so it is available to the entire app.

If you want the user to be able to type the formula itself, then you'll need to use the eval function.

JimD.

If the formula is constant and the inputs are just that, inputs to the formula, then I would code it in a Function procedure in a general module so it is available to the entire app.

If you want the user to be able to type the formula itself, then you'll need to use the eval function.

JimD.