Run code each time form is opened

[brandonboucher]

Hey everyone,
The problem i'm need help on is that I have a every time this form opens (ResourceForm) I need the following code to run to flip the checkbox value. This works when adding the code to a button but not for when the form loads. I feel like there's something incredibly simple that i'm missing and initialize doesn't seem to be the answer as i'll be opening this form many times. Any help would be greatly appreciated!

User flow:
If the selected text appears in the cell when the form is opened the corresponding checkbox will be true.

Public Sub ResourceForm_Activate() 
    Dim celltxt As String
    celltxt = ActiveSheet.Range("E9").Value
    If InStr(celltxt, "SSS1B", vbTextCompare) Then
        CheckBox1.Value = True
    Else
        CheckBox1.Value = False
    End If
End Sub

InsertResource_Test.xlsm