Can't automatically add checkboxes when adding rows

Hello,
First let me say that this site is great. I have learned a lot but still have a lot of stuff I have no clue about.
I have a form that we use for custom pricing.
I want to add check boxes starting at cell T17 through T36.
If possible, when I had a row I would like the check box to populate

Also, i some what understand how to assign a check box to a cell but can a macro automatically do this?


I appreciate any assistance.
Thank you
BCurry

Hello,

check boxes should be used in user forms, not in cells. If you add a check box, you need code to evaluate if the box is ticked or not in order to do something with it.

Instead, use a regular cell, format it with the Marlett font and enter an "a" (without the quotes) for a check mark.

You can then use that cell value in formulas, for example to sum all rows where that column contains an "a".

To do that with check boxes would be way more complicated.

cheers,

Code can add a checkbox. I agree that using the Marlett font might be better though.
Record a macro creating a checkbox, then modify the macro to create as many checkboxes that you want.

This will just get you started. Put this in the Sheets("Bid List") module.

Please Login or Register  to view this content.

That error is saying that you have 2 "Worksheet_Change" subs in the same module. You will need to combine the 2 into 1 which shouldn't be a problem.