LinkBack URL
About LinkBacks
Hello,
On my '2011 Ford F150'! sheet I inserted rows but there are not check boxes added on those rows. Is there a way to keep check boxes on every row in the table if new rows are added?
Thank you
Hello,
On my '2011 Ford F150'! sheet I inserted rows but there are not check boxes added on those rows. Is there a way to keep check boxes on every row in the table if new rows are added?
Thank you
You have to manage it with macros. You would use your Worksheet_Change sub to detect insertions and then use code similar to AddCheckBoxesRange to add the checkbox when appropriate.
I can't figure out your logic for linked cells. In that table the cells linked to the checkboxes seem to have no pattern. For example, the box in O13 is linked to P14; the box in O8 is linked to P7.
I also can't see why some rows have no checkboxes.
People like checkboxes because they look cool but having one on every row has its challenges, as you have found. In tables like yours I just use one column to put an X. Then your formula in D
=IF($P8=TRUE,$G$2,"")
becomes
=IF($P8="x",$G$2,"")
I have a macro that when selecting the range will insert check boxes and assign the adjacent next cell for validity.
The pattern is altered because I inserted rows and then sorted the column for 'Services'.
It would be nice if this was more dynamic if possible.
Can you take a look again please?
I explained how you need to modify your existing code to automatically insert checkboxes in new rows. I also gave you an alternative solution to your whole setup that would not require any code and be impervious to inserting and sorting. What is it you want me to look at again?
I don't understand how to modify my existing code to automatically insert checkboxes in new rows.
I like having the check boxes so I will manage by manually adding them as the need changes for new rows.
Thank you for the suggestions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks