Copying Rows Represented By Checked Checkboxes

[sandy1977]

Hi guys,

After doing some reading within the forum I was able to get to the point to where I'm at.

I Currently I have a table with a list of products and checkboxes besides each item, where if the checkbox is checked, it will copy the whole row to Sheet1. As shown below:

2017-01-02_15-59-37.png 2017-01-02_16-03-37.png

I want to be able to delete a row after I uncheck a particular item, if I change my mind.

The formatting after it has been copied to my destination sheet is also messed up.

I have attached the workbook if needed. I'm using a Private Sub for each of the Checkbox, if selected.

Bonus help: If it all possible, I would like to have the items that are checked, to show on the right had side of my items, within the same sheet, as shown below:

2017-01-02_16-10-37.png

Thank you in advance for any help provided. If there is a better way to do this, I'm open to suggestions as well, I'm no expert in the matter.

[mikerickson]

Your ActiveX controls aren't supported by my Mac, so I removed them and replaced them with Marlett CheckBoxes, Double click on a cell in Column B and the cell will become checked (or unchecked).

[sandy1977]

Perfect Mike, that works.

Is it possible to have that same data besides (to the right hand side) the main table, within the Consumables worksheet?

pic.png

[mikerickson]

Add this to the end of CopyProductData

Please Login or Register  to view this content.

[dangelor]

A macro to check all checkboxes at one time and copy the info in each row...

Please Login or Register  to view this content.

[sandy1977]

Excellent Mike, thank you so much for your help!!

[sandy1977]

Thanks Dangelor, although is not what I'm looking for, I appreciate you taking the time to help me.

[sandy1977]

Thanks Dangelor, although is not what I'm looking for, I appreciate you taking the time to help me.

[sandy1977]

Sorry dangelor, I spoke too soon, that worked as well, like I needed it. Thank you so much for your time in helping me.