checkbox

crt · May 23rd, 2002, 03:01 PM

how do i use a checkbox to affect the value in another cell. I want to subtract the cell amount from another column only when the box is checked

lenze · May 23rd, 2002, 03:08 PM

Assumming you are using a checkbox from the Form Toolbar
Right Click on the Checkbox and choose Format Control. On the Control tab, enter a cell reference in the Cell Link. This can be a hidden cell or on another sheet. When the checkbox is activated, this linked cell will be either True or False. Now use a formula with the IF funtion to achieve your desired formula. =IF(Linked Cell="TRUE", Do Something,Do Something Else)

Note:A Checkbox from the control toolbar is linked in the properties window.

[ This Message was edited by: lenze on 2002-05-23 14:12 ]

crt · May 23rd, 2002, 03:14 PM

I do not have Format Control as a choice

crt · May 23rd, 2002, 03:19 PM

thanks for the help i did find the properties. I used the control toolbar

lenze · May 23rd, 2002, 03:20 PM

When you right click omn the control, it should be your last option on the menu. But once you have selected the control, you can open the Format Control dialog by double clicking on the Control's border

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 03:01 PM	#1
crt New Member Join Date: May 2002 Posts: 11	how do i use a checkbox to affect the value in another cell. I want to subtract the cell amount from another column only when the box is checked

May 23rd, 2002, 03:08 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Assumming you are using a checkbox from the Form Toolbar Right Click on the Checkbox and choose Format Control. On the Control tab, enter a cell reference in the Cell Link. This can be a hidden cell or on another sheet. When the checkbox is activated, this linked cell will be either True or False. Now use a formula with the IF funtion to achieve your desired formula. =IF(Linked Cell="TRUE", Do Something,Do Something Else) Note:A Checkbox from the control toolbar is linked in the properties window. [ This Message was edited by: lenze on 2002-05-23 14:12 ]

May 23rd, 2002, 03:14 PM	#3
crt New Member Join Date: May 2002 Posts: 11	I do not have Format Control as a choice

May 23rd, 2002, 03:19 PM	#4
crt New Member Join Date: May 2002 Posts: 11	thanks for the help i did find the properties. I used the control toolbar

May 23rd, 2002, 03:20 PM	#5
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	When you right click omn the control, it should be your last option on the menu. But once you have selected the control, you can open the Format Control dialog by double clicking on the Control's border