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!



" wrote:

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 (& risk holding up an order due to incorrect pricing), I
want them to select a check box. When "red hats" are checked I want $1.00 to
show up in AE20 and when "green hats" 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.