Hi. I am typically an MS Access developer, although I've done a few projects with Excel automation and I am quite comfortable with VBA.
I am duplicating an Access entry form in Excel (for those who don't use Access) for a Risk Assessment database.
I need to place multiple checkboxes in a cell (or I can use a stack of cells).
I figured out how to make the checkbox work so that a cell stores the value.
NOW, what I need to do is to take the whole line with multiple columns, including the multiple checkboxes and copy it's formulas, formatting (and checkboxes) down creating about 40 copies (lines). Each line represents a type of Risk and each Risk-type has 12 body parts that may be affected (checkboxes).
I can't figure that out, because even though a checkbox hovers over the cell it really doesn't copy over, like a formula would. Plus it's corresponding VBA procedure has to be copied.
any ideas? I would hate to set up 40*12 checkboxes + VBA subs!
Thanks!
I am duplicating an Access entry form in Excel (for those who don't use Access) for a Risk Assessment database.
I need to place multiple checkboxes in a cell (or I can use a stack of cells).
I figured out how to make the checkbox work so that a cell stores the value.
NOW, what I need to do is to take the whole line with multiple columns, including the multiple checkboxes and copy it's formulas, formatting (and checkboxes) down creating about 40 copies (lines). Each line represents a type of Risk and each Risk-type has 12 body parts that may be affected (checkboxes).
I can't figure that out, because even though a checkbox hovers over the cell it really doesn't copy over, like a formula would. Plus it's corresponding VBA procedure has to be copied.
any ideas? I would hate to set up 40*12 checkboxes + VBA subs!
Thanks!
