say, in column A to D, I want to check if the data entered in A1 is higher than D1 -
meaning: value at column A should not be higher than corresponding row in column D.
is it Workbook_Change or Workbook_SelectionChange that will manage the checking?
how do we write the code?
many many thanks