I have a form that has a log number (i.e. E29029) that gets approved and and
the first character gets removed and the new number replaces the one in the
actual data log (i.e. E29029 becomes 29029). How would I go about verifying
that there is not a duplicate in the data log prior to changing the cell
(i.e. if EOTemp = cells (X,y) or EONo = cells(x,y) then msgbox"Duplication
error, press ok to open the log for editing"
else
cells(x,y) = EONo.

Thanks in advance