CheckBox Programming

**[email protected]** · 04-13-2010, 10:49 AM

Hey guys,

I have a user that has added a check box to their excel sheet and wants to only sum the cells next to the box that is checked... Anyone have a clue how to do this? I would assume the user will have to determine if the box is checked then some how add the cell next to it to their sum statement, but not really sure how to go about that. Ideas?

Thank you in advance,

Jon

**contaminated** · 04-13-2010, 10:56 AM

What kind of checkbox is it? Is it Form Control or Activex Control??? Can you post you sample workbook to see ...

**[email protected]** · 04-13-2010, 11:02 AM

It's a form control. The user has left, but I could probably get a sample tomorrow.

**contaminated** · 04-13-2010, 11:18 AM

So if it is Form Control

Right click on your control and select "Format Control" option. Dialog box pops-up.
There's "Cell Link" field on Control tab. Say your cell link is A1 (See image1). So when you fill the check box A1 will return TRUE , when you uncheck A1 will become FALSE. Using these logical staements you cxan do whatever you want. For example you wanna sum B1:B10 when checkbox is filled. So try this formula in C1
=IF(A1,SUM(B1:B10),"Unchecked")