Checkboxes In Excel 2003

Good Afternoon everyone,

I'm an excel noob and I'm trying to make up pricing sheets that I can insert check boxes. I have a list of options for each product and I when I click certain options I want them to sum up the cost of each option in another cell. I hope this makes a little sense.

Cheers

pagelite

Hello & Welcome to the Board,

Personally I would shy away from check boxes. Instead this double click method to simulate a check box is a cleaner way to go.

In column c you will double click adding the check and in F2 the sum will in-turn give you the answer of all the checked cells.

Like this...

Remember to enable the macros...

You are most welcome...Glad I could help in some way

The best way to explain this method is to send you to another thread.

http://www.mrexcel.com/forum/showpos...05&postcount=5

Also, don't miss the Alternative Checkboxes link...

Please let me know if you have anymore questions, but if not and you are satisfied with the solution provided, please do not forget to mark the thread as solved.

Look at my signature block.

Originally Posted by Pagelite

1. I used the script that you used in your example and I don't see how to change where the information is populated like it was in Cell D,52

Cell D52 is simply a formula -- =SUMIF(range,criteria,sum_range)

Originally Posted by Pagelite

2. Do i have to turn Macros on/off and if so where do I do it?

Yes the macros need to be enabled. I don't have 2003 so not quite remembering what I did then, but don't think it's much different than 2007.

When file is opened, at the top of the screen there is a Options button with a security warning to enable macros. If you trust the source then you enable the macros.

You can do a google search for 2003 enable macros.

Originally Posted by Pagelite

3. This Worksheet will be used by multiple people once it is correct. Is there away of saving it in read-only mode so they only have too double click in the boxs and not type the "a" in the cell with "marlett" as the font?

When you enable the macros the double click will work for column A. You do not have to add the "a" or the marlett font, the macro does this for you.

Here are the steps I took to setup the spreadsheet.

Enable Macros
Open up the name manager (Ctrl + F3)
New >> Name >> MyChecks >> Refers to: =Sheet1!$A$15:$A$50 >> Ok >> Close
Copy code

Please Login or Register  to view this content.

Right Click on sheet tab with the info >> View Code >> Paste code on right side of screen
Alt + Q will close the VBE and return you to Excel
In D52 write the formula =SUMIF(MyChecks,"a",D15:D50) =SUMIF(range,criteria,sum_range)
range >> MyChecks refers to the named range we created
criteria >> searching for "a" (which the font martlett displays as a check mark
sum_range >> D15:D50 (we could have made this a named range also)

Now double click on any cell in column A and the associated dollar amount in column D will total up in D52