Checkbox trigger macro

[rikvny02]

I have a very simple macro to run based off a checkbox and it either doesn't work or it crashed my workbook. Please help.

Private Sub Worksheet_Change(ByVal Target As Range)
If CheckBox12 Then
completed
End If

End Sub


Sub completed()
[j36] = Environ("username") & " " & Now


End Sub

 

[rikvny02]

To be certain that we're on the same page,
these are sheet modules
View attachment 88454

these are userform modules
View attachment 88456

these are standard modules
View attachment 88457
If the checkbox control is on a sheet and both subs are in a sheet module, both should run as long as the first one runs and checkbox is True.
If checkbox is on a sheet and you moved completed() to a standard module, it should error because completed() would have no awareness of where J36 is. For that reason, I suspect you have your module terminology incorrect. Either that or you did move it to a standard module but included a sheet reference that you're not showing.

I currently have Completed() in Standard Module 1 and Checkbox in Sheet1 module. Everything works great.
When both the Checkbox and Completed() were in the same sheet module nothing work.