software

Help. I am creating an order form for my customers. We have a standard
product and then a few options. Rather than have my customers type the price
of the options in (amp; risk holding up an order due to incorrect pricing), I
want them to select a check box. When quot;red hatsquot; are checked I want $1.00 to
show up in AE20 and when quot;green hatsquot; are checked I want $2.00 to show up in
AE21.
I guess I want a set value to populate a cell when a box is checked.

right click on your check box and go to format control
select ad20 and ad21 as your cell link,in ae20(and similar in ae 21) type
=if(ad20=true,1,0).This assumes your checkbox is from FORMS toolbar
--
paul
remove nospam for email addy!
quot; wrote:

gt; Help. I am creating an order form for my customers. We have a standard
gt; product and then a few options. Rather than have my customers type the price
gt; of the options in (amp; risk holding up an order due to incorrect pricing), I
gt; want them to select a check box. When quot;red hatsquot; are checked I want $1.00 to
gt; show up in AE20 and when quot;green hatsquot; are checked I want $2.00 to show up in
gt; AE21.
gt; I guess I want a set value to populate a cell when a box is checked.


Hi,
I would use radio buttons, you can group them together by putting a
group box around them and each button within a group has it's own value
and is linked to the same cell. Reserve a column to link to...say A,
then to pull the value amount corresponding to the radio button
selected with:
=LOOKUP(A1,{1,2},{5,10})
{1,2} are the button values
{5,10} are the corresponding values...in your case $5 and 10$

Note. you can not use $ in that formula.

HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=498123Thank you Paul, this is exactly what I needed.
K.

quot;paulquot; wrote:

gt; right click on your check box and go to format control
gt; select ad20 and ad21 as your cell link,in ae20(and similar in ae 21) type
gt; =if(ad20=true,1,0).This assumes your checkbox is from FORMS toolbar
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot; wrote:
gt;
gt; gt; Help. I am creating an order form for my customers. We have a standard
gt; gt; product and then a few options. Rather than have my customers type the price
gt; gt; of the options in (amp; risk holding up an order due to incorrect pricing), I
gt; gt; want them to select a check box. When quot;red hatsquot; are checked I want $1.00 to
gt; gt; show up in AE20 and when quot;green hatsquot; are checked I want $2.00 to show up in
gt; gt; AE21.
gt; gt; I guess I want a set value to populate a cell when a box is checked.

PM,
Thank you for the information. Unfortunately it is way over my head. I
don't know what radio buttons are and could not find them in the Excel help.
Your solutions looks very interesting and it appears that the check box opton
will not allow a $ and a radio does. Do I understand this correctly? If
you don't mind helping, I could realy use it. I want my form to be as
professional looking as possible. Thank you for your time and efforts.
K.

quot;pinmasterquot; wrote:

gt;
gt; Hi,
gt; I would use radio buttons, you can group them together by putting a
gt; group box around them and each button within a group has it's own value
gt; and is linked to the same cell. Reserve a column to link to...say A,
gt; then to pull the value amount corresponding to the radio button
gt; selected with:
gt; =LOOKUP(A1,{1,2},{5,10})
gt; {1,2} are the button values
gt; {5,10} are the corresponding values...in your case $5 and 10$
gt;
gt; Note. you can not use $ in that formula.
gt;
gt; HTH
gt; JG
gt;
gt;
gt; --
gt; pinmaster
gt; ------------------------------------------------------------------------
gt; pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
gt; View this thread: www.excelforum.com/showthread...hreadid=498123
gt;
gt;