D
DD
I am trying to get users to enter all required fields. How do I stop users
from not filling out a required field
from not filling out a required field
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
robert111
write an if statement that tests all your fields, and if any one i
blank, display a banner saying YOU HAVE ONE OR MORE FIELDS STILL T
COMPLET
blank, display a banner saying YOU HAVE ONE OR MORE FIELDS STILL T
COMPLET
D
Dave Peterson
I use an adjacent cell with a formula like:
=if(a1<>"","","<-- Must be filled in!")
And I make it big bright bold red.
=if(a1<>"","","<-- Must be filled in!")
And I make it big bright bold red.
D
DD
Thank you that worked well
D
DD
Thank you - worked brilliantly
Dave Peterson said:I use an adjacent cell with a formula like:
=if(a1<>"","","<-- Must be filled in!")
And I make it big bright bold red.
G
Gord Dibben
And if they choose to ignore the warning..........what then?
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
D
Dave Peterson
You scream at them!
Gord said:And if they choose to ignore the warning..........what then?
Gord Dibben MS Excel MVP
G
Gord Dibben
Not in the enlightened corporate world I was working in for the past 15 years.
No punching, slapping, screaming, derogatory statements or any other non-PC
behaviour.
Employing the fruits of your sensitivity training, you gently point out that
they have not followed instructions quite as you wished and could they possibly,
if so inclined, fill out the required cells between breaks and attending group
hugs sessions.
I am soooooooooooooooo happy to be out of it.
Gord
No punching, slapping, screaming, derogatory statements or any other non-PC
behaviour.
Employing the fruits of your sensitivity training, you gently point out that
they have not followed instructions quite as you wished and could they possibly,
if so inclined, fill out the required cells between breaks and attending group
hugs sessions.
I am soooooooooooooooo happy to be out of it.
Gord
D
Dave Peterson
You left out surfing the web!
Gord said:Not in the enlightened corporate world I was working in for the past 15 years.
No punching, slapping, screaming, derogatory statements or any other non-PC
behaviour.
Employing the fruits of your sensitivity training, you gently point out that
they have not followed instructions quite as you wished and could they possibly,
if so inclined, fill out the required cells between breaks and attending group
hugs sessions.
I am soooooooooooooooo happy to be out of it.
Gord
R
robert111
In the spirit of contributions so far, test if they have complied with
your wishes, ie are any cells blank, and if so, automatically send an
e-mail asking them to fill out all outstanding fields, AND COPY THIS TO
THEIR BOSS. If no improvement, next time ALSO COPY TO BOSS'S BOSS.
Calculate how much this rework is costing in dollars, and send an
E-mail to the Financial Vice-President. Update your resume / CV just in
case.
Robert
your wishes, ie are any cells blank, and if so, automatically send an
e-mail asking them to fill out all outstanding fields, AND COPY THIS TO
THEIR BOSS. If no improvement, next time ALSO COPY TO BOSS'S BOSS.
Calculate how much this rework is costing in dollars, and send an
E-mail to the Financial Vice-President. Update your resume / CV just in
case.
Robert