Manual Entry without deleting formula

Hi-

I have searched all over for this, but I thought I just make sure. I want to somehow have a manual entry allowed in a field that contains a formula, without losing the formula. Many places I've searched say this is not possible, but there have been a couple of times I've found people who posted VBAs that said they would allow the field to contain a manual entry and if that entry was then cleared, the formula would return to the field. I tried their posts, but I couldn't get them to work. Can anyone assist me on this? Is there any other way? My other thought was that I only need the manual entry values to allow either a blank space or a "+1" in the field. Is there a way to do a conditional drop-down menu that only appears if it is triggered by specific data in another field? Does that make sense?

I really appreciate any help you could provide on this issue. If you need me to go in to details on the specifics of what I'm looking for, please let me know.


-G

You can allow manual entry to another cell (e.g. M1), and then amend your formula like this:

=IF(M1<>"",M1,your_existing_formula)

so that if there is an entry in M1 it will be returned rather than the result of the formula.

Hope this helps.

Pete

"Using VBA, you could probably have the value be entered, then, given certain criteria, have that value over-written with the formula again"

Yes, that's what I'm trying to figure out how to do, with VBA, but I'm not really at the point where I could write that myself, so I'm trying to find someone else's script I could use. Would you know how I would write that?