Hi,

I was given a task to create a workbook with 5 worksheets. On eac
worksheet I am suppose to created fields for another person to fill in
For example, I will have:

Name Hrs Wage Payment

and then the other person will fill it in accordingly.

So in the end we will have something like this:

Name Hrs Wage Payment
John 5 2.50 12.50
Mark 20 1.00 20.00
Thomas 10 5.00 50.00


But let's say there is an item missing, such as 10.

Is there a code that can run when I attempt to close the file to searc
for empty fields on each worksheet and have a box pop up and displa
which field was missing before the file closes?

Thank you. Any input would be helpful. Thanks in advance.

a

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

Look in your other thread in Functions

--
Regards Ron de Bruin
http://www.rondebruin.nl


"ajlove20 " wrote in message ...
Hi,

I was given a task to create a workbook with 5 worksheets. On each
worksheet I am suppose to created fields for another person to fill in.
For example, I will have:

Name Hrs Wage Payment

and then the other person will fill it in accordingly.

So in the end we will have something like this:

Name Hrs Wage Payment
John 5 2.50 12.50
Mark 20 1.00 20.00
Thomas 10 5.00 50.00


But let's say there is an item missing, such as 10.

Is there a code that can run when I attempt to close the file to search
for empty fields on each worksheet and have a box pop up and display
which field was missing before the file closes?

Thank you. Any input would be helpful. Thanks in advance.

aj


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