Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks guys.
Unfortunately that's not exactly what I'm looking for. Let's say I have linked the first checkbox in A1 to the value in A1 so if I check and uncheck that checkbox the value toggles between true and false. Now I would like to select the right-below corner of A1 and drag it to F1 in a way that all cells relate to the checkbox that is in the respective cell (checkbox in cell B2 relates to cell B2). Another question: how can you select more than one checkbox and delete them? john "john" schreef in bericht ... I want the cell to change when the checkbox is changed and I have got that working for one checkbox and the respective cell. Maybe Autofill isn't the right word but I want to select the left-right-corner of the first cell with the checkbox and drag it 176 cells further so that 176 checkboxes are made and related to the cell they reside in. "stevebriz" schreef in bericht oups.com... do you want the cell to change when the checkbox is change or vice versa? john wrote: In my spreadsheet I need 177 checkboxes all linked to the cell they reside in. Is there a way to make one checkbox link it to the right cell and then autofill the other 176 checkboxes? The way I'm doing it now is not working as I have to make the link to the respective checkbox 176 times checkbox for checkbox. thanks, john |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Checkboxes | Excel Programming | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Q. Autofill question: Can I autofill alpha characters like I can numbers? | Excel Programming | |||
checkboxes | Excel Programming | |||
Checkboxes | Excel Programming |