I am trying to get users to enter all required fields. How do I stop users
from not filling out a required field

write an if statement that tests all your fields, and if any one is
blank, display a banner saying YOU HAVE ONE OR MORE FIELDS STILL TO
COMPLETE


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=558766

I use an adjacent cell with a formula like:

=if(a1<"","","<-- Must be filled in!")

And I make it big bright bold red.



DD wrote:

I am trying to get users to enter all required fields. How do I stop users
from not filling out a required field

--

Dave Peterson

Thank you that worked well

"robert111" wrote:


write an if statement that tests all your fields, and if any one is
blank, display a banner saying YOU HAVE ONE OR MORE FIELDS STILL TO
COMPLETE


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=558766

Thank you - worked brilliantly

"Dave Peterson" wrote:

I use an adjacent cell with a formula like:

=if(a1<"","","<-- Must be filled in!")

And I make it big bright bold red.



DD wrote:

I am trying to get users to enter all required fields. How do I stop users
from not filling out a required field

--

Dave Peterson

And if they choose to ignore the warning..........what then?


Gord Dibben MS Excel MVP

On Thu, 6 Jul 2006 23:31:01 -0700, DD wrote:

Thank you - worked brilliantly

"Dave Peterson" wrote:

I use an adjacent cell with a formula like:

=if(a1<"","","<-- Must be filled in!")

And I make it big bright bold red.



DD wrote:

I am trying to get users to enter all required fields. How do I stop users
from not filling out a required field

--

Dave Peterson

You scream at them!

Gord Dibben wrote:

And if they choose to ignore the warning..........what then?

Gord Dibben MS Excel MVP

On Thu, 6 Jul 2006 23:31:01 -0700, DD wrote:

Thank you - worked brilliantly

"Dave Peterson" wrote:

I use an adjacent cell with a formula like:

=if(a1<"","","<-- Must be filled in!")

And I make it big bright bold red.



DD wrote:

I am trying to get users to enter all required fields. How do I stop users
from not filling out a required field

--

Dave Peterson


--

Dave Peterson

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


On Fri, 07 Jul 2006 11:36:05 -0500, Dave Peterson
wrote:

You scream at them!

Gord Dibben wrote:

And if they choose to ignore the warning..........what then?

Gord Dibben MS Excel MVP

On Thu, 6 Jul 2006 23:31:01 -0700, DD wrote:

Thank you - worked brilliantly

"Dave Peterson" wrote:

I use an adjacent cell with a formula like:

=if(a1<"","","<-- Must be filled in!")

And I make it big bright bold red.



DD wrote:

I am trying to get users to enter all required fields. How do I stop users
from not filling out a required field

--

Dave Peterson

You left out surfing the web!

Gord Dibben wrote:

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

On Fri, 07 Jul 2006 11:36:05 -0500, Dave Peterson
wrote:

You scream at them!

Gord Dibben wrote:

And if they choose to ignore the warning..........what then?

Gord Dibben MS Excel MVP

On Thu, 6 Jul 2006 23:31:01 -0700, DD wrote:

Thank you - worked brilliantly

"Dave Peterson" wrote:

I use an adjacent cell with a formula like:

=if(a1<"","","<-- Must be filled in!")

And I make it big bright bold red.



DD wrote:

I am trying to get users to enter all required fields. How do I stop users
from not filling out a required field

--

Dave Peterson


--

Dave Peterson

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


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=558766