Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i change the value of a cell with a checkbox
I'm trying to have a cell value changed on the click of a checkbox. The total
value of the cell must change according to the checkbox selected. It's for an automated expense account sheet which calculate the amount of mileage done in a month and a grand total of the entire year along with monthly reimbursement. Tx for any help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i change the value of a cell with a checkbox
Private Sub CheckBox1_Click()
If Range("A1").Value = True Then ' <=== Linked Cell for Check box (Check Box Properties) Range("B1").Value = "100" '<======== Cell(B1) is the cell value you want to modify depending on check box result Else Range("B1").Value = "200" End If End Sub Corey.... "Rollie13" wrote in message ... I'm trying to have a cell value changed on the click of a checkbox. The total value of the cell must change according to the checkbox selected. It's for an automated expense account sheet which calculate the amount of mileage done in a month and a grand total of the entire year along with monthly reimbursement. Tx for any help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i change the value of a cell with a checkbox
In design view, open the properties sheet for the check box. Enter a cell
reference in the LinkedCell property. This cell will be True if the check box is ticked and false if it isn't. You can then test the cell in your formula. "Corey" wrote: Private Sub CheckBox1_Click() If Range("A1").Value = True Then ' <=== Linked Cell for Check box (Check Box Properties) Range("B1").Value = "100" '<======== Cell(B1) is the cell value you want to modify depending on check box result Else Range("B1").Value = "200" End If End Sub Corey.... "Rollie13" wrote in message ... I'm trying to have a cell value changed on the click of a checkbox. The total value of the cell must change according to the checkbox selected. It's for an automated expense account sheet which calculate the amount of mileage done in a month and a grand total of the entire year along with monthly reimbursement. Tx for any help |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i change the value of a cell with a checkbox
Tx u 2 for the prompt answer.
I tested it and it worked great. Tx again "Vaughan" wrote: In design view, open the properties sheet for the check box. Enter a cell reference in the LinkedCell property. This cell will be True if the check box is ticked and false if it isn't. You can then test the cell in your formula. "Corey" wrote: Private Sub CheckBox1_Click() If Range("A1").Value = True Then ' <=== Linked Cell for Check box (Check Box Properties) Range("B1").Value = "100" '<======== Cell(B1) is the cell value you want to modify depending on check box result Else Range("B1").Value = "200" End If End Sub Corey.... "Rollie13" wrote in message ... I'm trying to have a cell value changed on the click of a checkbox. The total value of the cell must change according to the checkbox selected. It's for an automated expense account sheet which calculate the amount of mileage done in a month and a grand total of the entire year along with monthly reimbursement. Tx for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
change cell color to red & then green when value change in 2 cel | Excel Discussion (Misc queries) | |||
insert date | Excel Worksheet Functions | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Cell Change Color - Need Help | New Users to Excel |