Move row if box is checked

[Hank Moore]

Hello,
I apologize but I was unable to find where this exact question/issue was already asked in the forums....
I would like to create a to-do list where once the task is completed, a check box is ticked and the row is moved to a sheet titled 'Action items completed'. I know how to create the check box but unsure what code is needed to have the row moved
Thank you in advance!

 

[Peter Bartholomew]

Moving a row constitutes a change of state which is not permitted in a functional programming environment such as Excel.
I suggest the question should be moved or re-posted on the VBA macros forum.

 

[Marc L]

Hello, right but without any workbook attachment it is more for some guessing challenge garbage section rather than for VBA Macros …​

​

 

[vletm]

Hank Moore
Without Your sample file, here is one sample how to move row to other sheet.
This won't use any check boxes - select cell below MOVE-header and that's it.
With this sample, You can move from Sheet1 to Sheet2 and back.