Hi all,

Any suggestions on how you can make it so when a line is 'exited'
particular cell or cells hae to be filled in (i.e not left blank).

For example:

A B C

1 BOB 1 4

2 CAT 2

3 DAD 5 5

In the case above cell C2 should not be left blank and the user canno
leave the line until C2 is filled in. I say line because he might no
have clicked on the cell and so therefore it cannot be validate
against if he left the cell.

I hope i made myself clear.

Thanks in advance for all the great help.

Chri

--
chris10
-----------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...fo&userid=2516
View this thread: http://www.excelforum.com/showthread.php?threadid=48958