Autofilling buttons in cells, if a row is NOT empty

Hi there,

I have added some VBA code to your file. Click the button to populate the shapes.
This will:
- Copy the shapes (tick-boxes & comment box) in row 7. This also copies the tick box selection. We could move the default shapes onto another (hidden) sheet if preferred. Code would need to be updated.
- Check every following row for columns B, C or D not being empty.
- If not empty, we check if there are already any shapes in the row (preventing to overwrite previous check boxes..).
- If values found and no shapes in that row, the shapes from row 7 are copied into that row.

I have deleted some of your formulas for testing to ensure it works if only one or 2 of the 3 columns contain a value. Just pull down the formulas from row 7 to fill the blanks.
I have also left some tick boxes in some cells to test for them not being overwritten.

Note, the shapes have specific names. If they are different in the actual file, this will need to be updated.

Hope this helps.

Please Login or Register  to view this content.

Hi again,

You need to make sure each shape (group of check-boxes) is completely inside their row.
When they overlap, the macro will think there are already shapes in that row if part of the shape above or below is in that row.
I have adjusted them for you in the attached file.
You could also consider making the rows a bit higher to give the shapes a bit more room.

Cheers.