Working VBA code won't run in new file.

[cookeetree]

G'day Excel Gods,

I have a check box linked to a cell, with VBA code running from that. I don't know if I've gone about things "properly", but everything runs perfectly and I'm okay with that.

I created a new file, copied this code to it, and updated the cell references (the new worksheet is slightly different), yet I can't get the code to run when the check box is ticked or unticked.

Sub Determined_CheckBox()

If Range("F36") = True Then
Range("Z35") = "Enter Individiual Sample M.D.R. and Oversize Data"
Range("I36:Z43").ClearContents

End If

If Range("F36") = False Then
Range("Z35") = ""

End If

Range("I36").Select

End Sub


Any assistance you could provide would be greatly appreciated.

Cheer, Jason.

 

[dermie_72]

can you show the new sheet as well specifically cell F36, Z35 and I36:Z43

 

[rollis13]

Will work only if you have "Assigned" the macro to the checkbox and added the "Cell link" in its "Format Control".

 

[cookeetree]

Will work only if you have "Assigned" the macro to the checkbox and added the "Cell link" in its "Format Control".

Mate, you nailed it. I just assumed it would still be linked to that macro, but it wasn't. Works perfectly now. Thanks for your help!

 

[rollis13]

Thanks for the positive feedback, glad we were able to help.