Check Box in Excel

Copper Contributor

I have 2 worksheets in one job, one of the worksheets has checkboxes on each row. I would like to click on that checkbox and have the information in that row go to the other worksheet that I have setup. Is this possible?

3 Replies

@232schaper 

This would only work with VBA.
Please note that the control boxes must be set as a check box (ActiveX Control).
Here is a link with such an approach.

How To Move A Certain Row Into A New Sheet When Check Box Is Checked In Excel?

Standard disclaimer: This is a non microsoft site.

 

Hope I could help you with these information / links.

 

NikolinoDE

I know I don't know anything (Socrates)

this gets me very close I have 2 issues with this when I check the box the line is removed from sheet one I need it to stay and I have multiple lines with check boxes can i have a checkbox for each row?

Private Sub CheckBox1_Click()
Private Sub CheckBox2_Click()
Private Sub CheckBox3_Click()

create for each checkbox the same code :)