Commandbutton to copy based on CheckBox True/False

[TDNova]

Hello, im trying to figure out how to make this work.

I got a table with informaton. with a checkbox on the side of the table.
simply explained:
When the checkbox on the row is true, copy table row "b33" to a new table.
but i want it to be activated by a commandbutton, so i can choose 5 checkboxes before it starts to copy.

Is there a way for it to work without linking each and every checkbox to the cells?

I do not have enough knowlegde in excel to know which approach is best suited here.

 

[My Aswer Is This]

I missed seeing your previous post.

If sounds like your getting a error.
What line of code shows up in yellow.

 

[TDNova]

Haha, im so sorry. i did test it inn a new sheet with only your code.but i was overthinking it....
i could edit them , just not doubleclick to enter the cell to edit.

sorry for wasting your time, i tought i needed to enter the cell to edit it.

i created the problem with overthinking, so thanks for all the help.

 

[My Aswer Is This]

Are you now saying things are working?

 

[TDNova]

Are you now saying things are working?

Yes, yes i am.
everything looks good. the problem was just me understanding excel incorrect

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Yes, yes i am.
everything looks good. the problem was just me understanding excel incorrect

 

[My Aswer Is This]

You should be able to double click on any cell other then column (1) of Table(1) or column (1) of Table(2)
without any problem

These columns run your scripts when you double click on them.

 

[TDNova]

You should be able to double click on any cell other then column (1) of Table(1) or column (1) of Table(2)
without any problem

Nothing happens if i double click cells when macro/script is active. But i can single click the cell without entering it and then type in new information.
But that is no a problem.