Macro to add a new row with a checkbox

[mwilburn]

Good afternoon,

I am trying to create a macro that will insert a new row at the bottom of a table and add a checkbox to it. The goal is if a user needs to add 2 or 3 lines, they could run this macro 2 or 3 times. Thanks in advance!

 

[DanteAmor]

With this macro you add a row to Table1.
I do not understand why you need the checkbox, could you explain it?

sub AddRow
ActiveSheet.ListObjects("[COLOR=#0000ff]Table1[/COLOR]").ListRows.Add AlwaysInsert:= True
end sub

 

[mwilburn]

With this macro you add a row to Table1.
I do not understand why you need the checkbox, could you explain it?

sub AddRow
ActiveSheet.ListObjects("[COLOR=#0000ff]Table1[/COLOR]").ListRows.Add AlwaysInsert:= True
end sub

I've actually adjusted my sheet but here is what I am trying to do.

I have a section of my worksheet that contains a header row and several items, it's 7 rows by 10 columns. I need to create a button connected to a macro that adds a row either at the bottom or top of that section that, keeps my formatting, and adjust my formulas in the top right two cells. The checkbox I was going to us is now just a character but I need the newly created row to contain the macro that allows that character to change from a box to a checked box as well as the conditional formatting associated with it. This sounds WAY more confusing than it is and I am SURE that is my fault. I will attempt to ad an image.

 

[mwilburn]

 

[mwilburn]

I cannot get the image to work. I am obviously computer illiterate today.

https://flic.kr/p/2enqnPd

 

[DanteAmor]

Can you record a couple of macros for each of the insert row options that you handle? copy those macros and paste here