Calculated fields are always calculated, you can't enter data directly into
them, so if you want to replace something that has been entered you need to
use VBA.
Another possibility is to reference another field in your formula. For
example, if you are calculating Cost1 based on some number, you could enter
the value in Number1.
Len
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
