i have an excel form that i want that after the user enters data, whe
he tries to exit text box it validates the data for him and if it'
valid the background changes to white.
i currently have the colors changing if there is any data in the txtbo
at all. i would like it to be that it needs to have two names in th
field - the director's first and last name. so i want it to check th
the first word is more than one letter, followed by a space, and the
at least two more letters.

i am putting the code in the txtDirector_Exit event.
i know the changing color code, i need to code to check the data in th
box.

thanks in advance
tkapla

--
tkapla
-----------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...fo&userid=2298
View this thread: http://www.excelforum.com/showthread.php?threadid=46985