how to make checkbox true selecting then chaning 2nd box true when null

I have made this downtime tracking board with some vb scripts I have taken from the web and by trial and error, have got most of it to work.
What I am looking to do now is Col N and O, and P and Q. I currently have a Active X check box that inserts =NOW() when checked and clears the data when unchecked. What I was trying to figure out was Col J "Temp Location" if anything is selected but "blank" then checkboxes are blank, else any other selection from the list puts a check in the "time out" check box and the time fills in. When the selection from the "Temp Location" is changed back to "blank it places a check in the "Time In" checkbox.

I was trying how to figure out

if J4:J59 does not equal ""
then checkboxOUT.value = true
else checkboxOUT.value = false
then if J4:J59 changes back to ""
then checkboxIN.vaue = true
else checkboxIN.value = false

this is the code I have used sofar, becaue I can't figure how else to do it. I am trying to automate as much as possible.

Please Login or Register  to view this content.

Please play with the file and look at the vb code and have fun with it

Thanks in advance

Hello ferrum_equitis, and welcome to the forum.

Thanks for amending your thread title.