Enter data in cell, but keep formula as well.

[ultrawat]

I think I have seen this done, but I dont know how.

I would like to have a formula in a particluar cell which can be over-written by typing in data......but.... if the data is deleted, the formula 're-appears'....

Any advice would be greatly appreciated......

 

[Stormseed]

Are you talking about the undo option ? Ctrl+Z ?
I am sorry incase I did not understand your question

 

[RoryA]

You would have to use code - specifically the worksheet_change event - to monitor the cell for changes and re-enter the formula if the cell is blank

 

[Stormseed]

You would have to use code - specifically the worksheet_change event - to monitor the cell for changes and re-enter the formula if the cell is blank

Ahaa ! This never struck my mind though ! Yes to OP, you can do it !!!

 

[Weaver]

Maybe you could use the event with a hidden sheet containing the formulas? Or perhaps temporarily store them in the comment field, although you'd need code to dump them all there before you started, as I think once the worksheet_change event is activated, you've already lost the previous cell content.