Hi,

Please can someone help me?

I would like a vba code to do the following 3 requests please.

If column A is blank then nothing to happen.

If there is less than 8 characters in column A then I would like the VBA to find the last entry in column A and then highlight the cell in red and then a message box to say "Process Order number requires a min of 8 characters". Once the message box is okeyed then the cell to be cleared of the characters and colour.

If column A has 8 or more characters then it continues with the rest of my code.

Hope this makes sense.

Thanks
Dan