need code to copy/move data between sheets

R

Ron Berns

I guess I need more help.
I am unable to renumber the checkboxes to match the rows to link the cells.
I need to see what the For...Next routine would look like.
Any help would be appreciated.

Ron

P.S.

The reason I put this line in:

Sheets(1).CheckBox1.LinkedCell = "A7"

after deleting the row is because the delete destroys the original link.
If you do not re-establish the link, you will get an error message on the next iteration of your loop.
of code for a loop with some If statements and range parameters for both
worksheets. See the remarks after the code.of the checkbox. If you use Checkboxes from the Control Toolbox and then make
sure that your check boxes names are such that you can use a variable to loop
through them as you walk down the column with the linked cells, you could use a
For ... Next statement to test each one and do what you want. Does this help, or
do you want the code written for you.2007 workbook. I have check boxes in Column B of the Log sheet to signify if the
line is complete. There could be one item that is completed or there could be
ten items.box. Copy the information from Column D to Column L of the Marked row on sheet
Log to the next open row starting at column B in the sheet Completed Log.to remove the completed lines in sheet Log, uncheck the box and move the
remaining lines on the Log sheet up to fill the spaces.
 
J

Joel

Use the checkbox from the forms Toolbar (not control toolbox) with this code.
I'm checking every checkbox and then deleting the row rather than the
opposite way you proposed.

Sub removerows()

Const BoxChecked = 1
For Each bx In ActiveSheet.CheckBoxes

If bx.Value = BoxChecked Then
Range(bx.LinkedCell).EntireRow.Delete
bx.Delete
End If
Next bx


End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top