Hi expert,

I have an application that runs in a userform.
The user can click a button and then returns to Excel where he can put in up
to 1000 records of data (employees of a copany with their data, date of birth,
salary etc.)

How can i make sure that the user fills out all the nescessary cells ?
If the user puts in a line i need to check if the cells in column B,C,E,F and
G are filled in.
if one of the cells is not filled in, the application gives an error message
and is closed without saving.

I would rather have the program givean error message stating that the data
that is filled in the cells is not complete.

Is there a way to check this ?
Thanks,
Pierre

--
Message posted via http://www.officekb.com