Add Checkbox when New Row is Made

Occasional Visitor

Hi All,


I'm trying to find a way to automatically add checkboxes to particular cells when a new row of a table is made (e.g. pressing tab at the end column of a table to make a new row).


As far as I'm aware, checkboxes from the Developer tab can be somewhat automatically made by:

  1. Drag it to a cell
  2. Drag the autofill across to another cell (the bottom right square when clicking on a cell)
  3. New checkbox is duplicated onto the new cell

However, when making a new row, this does not duplicate without using the above method.


Is there a way to do this? Preferably without the need for a click-button macro


Thank you 

0 Replies