casualexceler
New Member
- Joined
- Sep 7, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I have a table where one column is the "completed" column.
When a task is completed, there is a drop down menu in the "completed" column with the "yes" option which the user can then select. This will then call a macro which I have written that will remove the row and paste it into a different worksheet to keep all the completed tasks in another worksheet.
I tried to write a code so that if any cells in from i4 to i400 has "yes" inputted via the dropdown menu it calls and executes the macro I've called "yes"
The following code loops between itself and the "yes" macro
Private Sub Worksheet_Change(ByVal Target As Range)
Set Target = Range("i4:i400")
If Target.Value = "yes" Then
Call yes
End If
End Sub
essentially once the macro runs, and completes it runs the above code again.
There is conditional formatting on the cell also - would this be triggering the loop?
When a task is completed, there is a drop down menu in the "completed" column with the "yes" option which the user can then select. This will then call a macro which I have written that will remove the row and paste it into a different worksheet to keep all the completed tasks in another worksheet.
I tried to write a code so that if any cells in from i4 to i400 has "yes" inputted via the dropdown menu it calls and executes the macro I've called "yes"
The following code loops between itself and the "yes" macro
Private Sub Worksheet_Change(ByVal Target As Range)
Set Target = Range("i4:i400")
If Target.Value = "yes" Then
Call yes
End If
End Sub
essentially once the macro runs, and completes it runs the above code again.
There is conditional formatting on the cell also - would this be triggering the loop?