I didn't alter your logic. I suspect your msgbox is being regenerated by
the next cell checked.

I doubt the code reflects what your business rules are. You probably need
to state in explicit terms what type of test you are trying to perform -
what the rules are.

--
Regards,
Tom Ogilvy

"Mark1ace1 " wrote in message
...
It is the second code I want..I have tried it but it only allows
customers to have one and message box does not kill itself after
clicking ok...

Mark

Thanks for the help ....:)


---
Message posted from http://www.ExcelForum.com/