VBA Function not detecting all 3 decimal places in cells

I have a code where

Please Login or Register  to view this content.

this only seems to be picking up those cells with 3 decimal places which have a value like 12.224 not something which has a value like 12.228

If I put in 12.228 it rounds it off to 12.23 automatically even though the actual value is 12.228

Is there a way to avoid this?

Thanks

I'm a bit confused what you are trying to do but I'm guessing what you want is worksheetfunction.rounddown instead of round.

if anyone enters more than 2 decimal places, a button check would check and highlight all the cells in a column which have more than 2 decimal places.

Ok, so in your code, for 12.228, round(cell.value, 2) returns 12.23 and therefore 12.228 is not greater than round(Cell.value,2).

What you can do is:
if not cell.value = round(cell.value,2) then

or use rounddown as per the previous post.