I have a piece of code as follows
If Range("FY05_deducuction_percentage").Value < 0.95 Then MsgBox "FY06 percentage has dropped below 95% of FY05 budget" & vbCrLf & "Please adjust the last figure entered!!!", _ vbExclamation, "Please edit the last number" Application.Undo
it works fine,, until somebody enters values in the formula bar, then the macro won't notice the value is less than 95%.. How can this be corrected? Thanks!