message for tom ol
 

i have it working of a sort it will no longer allow illegal entriesbut
the con format does not flag by means of the patten selected but the
program itself states that the user will not allow this entry that will
do for now still like to get it sorted but thanx for your help

thanx also to all that helped


--
kevatt
------------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...o&userid=30245
View this thread: http://www.excelforum.com/showthread...hreadid=519170