Excel VBA - Complicate Problem

[ajlove20]

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

 

[Ron de Bruin]

Look in your other thread in Functions