(1) I input records in the worksheet
(2) When I input in column A of any row (e.g. invno), it will check whether
the values exist in the column A of all rows, it yes, show dialog that
duplicate record.
(3) the coding should put on the lost focus event of cells in column A