Hi All
Can any help me with this problem
When a user enters a value from a drop down box in cell B4, then selects a value from a drop down box in D17, then goes back and changes the value in cell B4.
What i would like is a message box for the user "You are changing the value" if they then accept no dont change the value of B4, if they say yes to the prompt then delete the value in D17.
I have tried various If's and then ststements but it dos not work, one of the problems seem to be the drop down box & select change activates before the actual value changes.
Can anybody help with a suggestion please ?
I have attached a test copy for info