A
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
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