3 different things to happen in column A depending on the cell value

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

Hi davesexcel,

thank you for both options. I didn't think about data validation so I'll have a play and see which one I prefer.

Thanks again

Dan