software

Hi!

I have a workshhet where people are booking themselves for different
programs. But there is a limit, for example the SUM of D210 don´t
have to be more than 8. How do I stop a user to put in any number when
th SUM has reached 8?

Jack--
Jack Daniels
------------------------------------------------------------------------
Jack Daniels's Profile: www.excelforum.com/member.php...oamp;userid=31170
View this thread: www.excelforum.com/showthread...hreadid=508300
depends on how you form is set up,,,

you could put in a formula that flags a message up when the lesson is full,
say in d11 put in

=if(D210gt;8,quot;Program Fullquot;,quot;quot;)

and use data validation on cells d2 to d10 so that ppl can only enter 1 as
the figure

their are numerous way depending on the layout of your form and what you
want it to do

quot;Jack Danielsquot; wrote:

gt;
gt; Hi!
gt;
gt; I have a workshhet where people are booking themselves for different
gt; programs. But there is a limit, for example the SUM of D210 don´t
gt; have to be more than 8. How do I stop a user to put in any number when
gt; th SUM has reached 8?
gt;
gt; Jack
gt;
gt;
gt; --
gt; Jack Daniels
gt; ------------------------------------------------------------------------
gt; Jack Daniels's Profile: www.excelforum.com/member.php...oamp;userid=31170
gt; View this thread: www.excelforum.com/showthread...hreadid=508300
gt;
gt;