Check Box in Excel

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3173606%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ECheck%20Box%20in%20Excel%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3173606%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20have%202%20worksheets%20in%20one%20job%2C%20one%20of%20the%20worksheets%20has%20checkboxes%20on%20each%20row.%20I%20would%20like%20to%20click%20on%20that%20checkbox%20and%20have%20the%20information%20in%20that%20row%20go%20to%20the%20other%20worksheet%20that%20I%20have%20setup.%20Is%20this%20possible%3F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3173606%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3173606%22%20slang%3D%22en-US%22%3ECheck%20Box%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3173606%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%202%20worksheets%20in%20one%20job%2C%20one%20of%20the%20worksheets%20has%20checkboxes%20on%20each%20row.%20I%20would%20like%20to%20click%20on%20that%20checkbox%20and%20have%20the%20information%20in%20that%20row%20go%20to%20the%20other%20worksheet%20that%20I%20have%20setup.%20Is%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3173606%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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