Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi guys.
I searched for days to find the solution to adding a column of checkboxes down a table with 500 rows in it - a checkbox at the end of each row. The good news is that I eentually found that someone had posted a little VB code that did it nicely. I used some additional conditional formatting and now each individual row changes colour when the checkbox is ticked! It's a thing of beauty to a new user! The trouble is that when you get 100 or so rows down the table the checkboxes gets incrementally and noticeably out of alignment with the rows. I guess that a tiny vertical misalignment accumulates. By the time you get to the 500th checkbox, they have run out the bottom of the table, and gone well below it, and are completely out of vertical alignment by about 10 rows! Does anyone have any idea on how to align the checkboxes correctly to each cell they are sitting above? Or to put it another way; to each row they should relate to? Is there some kind of tweak to the VB code that will make them "snap" to a cell as the script runs? Is there another completely different solution to get a checkbox-like cell at the end of every row? Thanks for any help with this -- Westie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW DO I RE-NUMBERED MY NUMBER COLUMN AFTER I ADDED ROWS? | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Count on multiple values with duplicate rows | Excel Worksheet Functions | |||
Moving Multiple Rows at one time | Excel Discussion (Misc queries) | |||
Insert rows | Excel Worksheet Functions |