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/