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 |
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 |
All times are GMT +1. The time now is 06:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com