But, how can I know (either by VBA or another formula in an adjacent cell) if the user has chosen to over-ride the formula and key in a value in that cell?

As for an example of what I mean, albeit very simplified:

Formula in Cell (A2):

Code:

`=rHours*.2`

If rHours equals 10, then the resulting value of Cell (A2) would be '2'. I want the user to be able to over-ride this formula and enter what they want in cell (A2), but I want Cell (B2) to contain the value "User Over-ride" if the user truly enters something on their own. They may even 'play around' with entering various values and end up hand entering a '2' in cell (A2). In this scenario, I still want the cell (B2) to have the "User Over-ride" value if this is the case.