PrivateSub checkBox1_Change()
If checkBox1.value = true then
'....your code to move the row
Elseif checkBox1.value = false then
'....your code when the checkbox is not checked
End if
End sub

"KISS" wrote:

I want to add a checkbox option at the end of the row of data to return
certain, not all data in the row, to a separate file, preferably, or to
separte worksheet. If the box is checked the info from that row will return.