Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check boxes
Ok, my programming is a little rusty.
This is what I need to happen: I have a worsheet that contains 2 checkboxes. First..when I open the file I would like checkbox1 to have a check in it and none in checkbox2. If the user clicks on checkbox2, I would like to remove the check from checkbox1. I also would like the cell c43 to contain the value from worksheet2, cell h24. If the user then clicks on checkbox1, I would like the check removed from checkbox2 and the value in c44 to contain the value from worksheet2, cell i24. If anyone can help, that would be great! Tricia gall |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
check boxes
For the first part
Right click each of the check boxes and select properties. Then set the value to true for CHKBOX 1 and False for CHKBOX2 then part 2 Right click each of the check boxes and select view code paste the code below appropriate to each of the check boxes. then save Workbook ..close it and reopen.. and select enable macros Private Sub CheckBox1_Click() If CheckBox1.Value = True Then CheckBox2.Value = False Sheet1.Range("C43").Value = Sheet2.Range("H24").Value Else End If End Sub Private Sub CheckBox2_Click() If CheckBox2.Value = True Then CheckBox1.Value = False Sheet1.Range("C44").Value = Sheet2.Range("I24").Value Else End If End Sub '--------------------------------------------- gall wrote: Ok, my programming is a little rusty. This is what I need to happen: I have a worsheet that contains 2 checkboxes. First..when I open the file I would like checkbox1 to have a check in it and none in checkbox2. If the user clicks on checkbox2, I would like to remove the check from checkbox1. I also would like the cell c43 to contain the value from worksheet2, cell h24. If the user then clicks on checkbox1, I would like the check removed from checkbox2 and the value in c44 to contain the value from worksheet2, cell i24. If anyone can help, that would be great! Tricia gall |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
Check Box influencing other Check Boxes | Excel Programming |