A
Aaron Howe
I have a spreadsheet intended for use as a form, which
many users would fill out. Each of the required fields
have been validated for entry, and there is a simple piece
of code at the bottom with a conditional format to point
out items which should have been filled in and weren't.
I have a print macro which will warn users that if they
haven't filled out everything, they should go back and do
it now. What I would really love to do, is to point out
which items they missed, dependent on the type of form
they are completing. So, if for example they should enter
things in the following fields:
Name
Address
Postal Code
Telephone number
And they missed Name and Address, the print macro would
warn that those fields were missed out before printing. I
am not so good with setting variables in VB and would
appreciate any help you could give!!
many users would fill out. Each of the required fields
have been validated for entry, and there is a simple piece
of code at the bottom with a conditional format to point
out items which should have been filled in and weren't.
I have a print macro which will warn users that if they
haven't filled out everything, they should go back and do
it now. What I would really love to do, is to point out
which items they missed, dependent on the type of form
they are completing. So, if for example they should enter
things in the following fields:
Name
Address
Postal Code
Telephone number
And they missed Name and Address, the print macro would
warn that those fields were missed out before printing. I
am not so good with setting variables in VB and would
appreciate any help you could give!!