Run code each time form is opened

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

It should be UserForm_Activate, not formname_Activate.

Public Sub UserForm_Activate() 
Dim celltxt As String

    celltxt = ActiveSheet.Range("E9").Value

    If InStr(celltxt, "SSS1B") Then
          CheckBox1.Value = True
    Else
        CheckBox1.Value = False
    End If
    
End Sub

Hi brandonboucher,

Check the attached file and hope this will help you.

InsertResource_Test.xlsm


Regards,
Paresh J

Please mark this thread as SOLVED and click * Add reputation as way to say thanks..