I have a worksheet with formulas installed, but wish to allow the user to over-ride the formula and hand-key a value in the particular cell.
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):
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.
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.