I know this is generally backwards from how its usually done (that is to say when a checkbox is checked the link to another cell the value changes to "1") but I need a macro that looks at a range of cells in a column; "O18:O386", which are all going to be either "1" or "0" , and if its a "1", then the checkbox beside it in column "N" is going to be checked (TRUE). If its "0", then not checked.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
code to check a checkbox if value of cell is "1"
Understood, thank you. I should back up some and explain what the problem is:
The column beside the checkbox is hidden and is either a 1 or a 0 (linked to the checkbox beside it.)
The checkboxes are form control boxes.
I have 2 ways on the spreadsheet of sorting. commandbuttons for each field (column), and comboboxes for 4 fields (you remeber, you helped me get them working lol
)
WHenever the combobox is used, and then after I either hit the 'reset' button (which unsorts all) of select another sort command button is selected, the boxes are all alittle off inside the cell (row) which they reside in (all the rows are the same height and remain the same height)
So i found a macro that recenters all the boxes back to there original position centered in their cell. I just put that little bit of code at the end of each command that sorts/filters the data.... and that worked.
But, for whatever reason, it also removes the check inside the box... even though the "1" or "0" in the cell adjacent to it is still correct (but now that box doesnt have a check, even though the linked cell is still a 1(??) )
So I was thinking that if I insert ANOTHER code to check if the column is a "1", and if it is, then apply a check to the box beside it.
(this is all confusing, but it really isnt... just going to post some screenshots to help illustrate what its doing...)
The column beside the checkbox is hidden and is either a 1 or a 0 (linked to the checkbox beside it.)
The checkboxes are form control boxes.
I have 2 ways on the spreadsheet of sorting. commandbuttons for each field (column), and comboboxes for 4 fields (you remeber, you helped me get them working lol
WHenever the combobox is used, and then after I either hit the 'reset' button (which unsorts all) of select another sort command button is selected, the boxes are all alittle off inside the cell (row) which they reside in (all the rows are the same height and remain the same height)
So i found a macro that recenters all the boxes back to there original position centered in their cell. I just put that little bit of code at the end of each command that sorts/filters the data.... and that worked.
But, for whatever reason, it also removes the check inside the box... even though the "1" or "0" in the cell adjacent to it is still correct (but now that box doesnt have a check, even though the linked cell is still a 1(??) )
So I was thinking that if I insert ANOTHER code to check if the column is a "1", and if it is, then apply a check to the box beside it.
(this is all confusing, but it really isnt... just going to post some screenshots to help illustrate what its doing...)
Upvote
0
Ok, so here it is with the hidden column "O" un-hidden so you can see what the linked cell is for each checkbox:
So after running a sort/filter it looks like this: The data is still correct (the "1" 's are still in the right cells) but some of the boxes have now become unchecked.
some of the boxes are really off-center from their cell, as you can see: (this also shows the macro right before i run it manually)
continued in next reply...
So after running a sort/filter it looks like this: The data is still correct (the "1" 's are still in the right cells) but some of the boxes have now become unchecked.
some of the boxes are really off-center from their cell, as you can see: (this also shows the macro right before i run it manually)
continued in next reply...
Upvote
0
Upvote
0
