How do I insert checkboxes? How do I link them to data validation and vlookup?

Please see the attached example. The Order Form is populated based on the customer's answer to the question of how many computers they need service for. You will see the Data Validation for the question drop down menu, and the VLookUps for what populates the Product Price for each item based on their answer to the question.

1. I need checkboxes in the three places that say 'CHECKBOX'. How do I create these?

2. When an item's checkbox is checked, I would like it to put the Product Price for the checked item into that item's cell under Your Order Totals. When it is unchecked, I would like there to either be a 0 or nothing in that item's cell under Your Order Totals, whichever is easier. How do I do this?

3. It is mandatory that the customer purchases a Spyware Installation Package with their Service Package. Therefore, I need the checkbox next to "Spyware Installation Package" to automatically be checked and the Product Price populated as well as the Your Order Totals, based on their answer. If the customer would like the "Deluxe Spyware Installation Package", when they check the box next to that and the price populates under Your Order Totals, I want it to automatically uncheck the box next to "Spyware Installation Package", and unpopulate that price.

Any help that could be given would be so helpful!

Just FYI... the word 'CHECKBOX' is supposed to be next to the three line items. Pretty obvious, but just to clarify.

This is definitely getting close to what I need! Unfortunately, my boss specifically requested checkboxes, so I would prefer to do it that way.

I see your formulas in my order totals... J8 formula seems pretty basic (=IF(F8>0,I8,0). What about the other two... what is the LEN function? (=IF(LEN(F9)>0,I9,0).

Also, the way you have it formatted now, you can have both the Spyware Installation Package AND Deluxe Spyware Installation Package selected. Is it possible to just have one or the other?

It would be super helpful if you could provide a brief explanation on how you're doing what you're doing. My real spreadsheet contains confidential material so I had to make a dummy example to put on here, and therefore will be making the changes to my spreadsheet myself.

Thanks a ton for your help!

You're right, my fault. I had unprotected the sheet and must have done something to the "X" cells to mess it up. I see now.

And yes, those formulas make sense.

Thanks for your help! I'll be looking for your checkbox version!

Sorry for the delay, I couldn't access the website for some reason.

I'm working on applying your work to my spreadsheet. I'll let you know if I have any questions, or if I get it to work.

Thanks SO much! You're saving my job.

Ok I already have a question, lol.

I can only find the ActiveX and Control checkboxes. I have Excel 2007... where can I find these other checkboxes that you speak of?

YESSSS I got it to work!!!! GREAT instructions. Thank you!!! I've been working on this project every single day for a week straight and I just finished, thanks to you.